It seems like a simple problem, but I'm stuck: I have two data tables (A: Income B: Expenses). Both contain 2 columns: Income table: InvoiceDeliveryDate(A); LineNetAmount(A), Expense table: InvoiceDeliveryDate(B); LineNetAmount(B). There are dates when there is no expense but there is income, and vice versa. And there are dates when there is both income and expense in the table. I would like to make a simple single table with the first column containing all the dates, a separate column for Income (where there was no value there should be "0"). Column 3 contains Expenses (where there was no value there should be "0"). Pre-combining the two tables into one table is not a solution.
LinkedIn
Twitter
