Match tables data

Juacata

I can't find the way to join two tables by a column and leave in null or blank the rows that doesn't exist in the first one.

Below you can see an example of how the information can come:

This is what i need to output:

Age group	Count
Total # of Receivable	2.495
0-30 Days	807
30-60 Days	788
+60 Days	832
Total $ of Receivable	36361895.9
0-30 Days	14086065.61
30-60 Days	14349579.53
+60 Days	7926250.76
Total # of Payable	3.102
0-30 Days
30-60 Days	915
+60 Days	2.187
Total $ of Payable	27787401.5
0-30 Days
30-60 Days	1252104.02
+60 Days	15635297.48

ddiesel

Hi @Juacata!

There has GOT to be an easier way to do this, but here's where my brain went with it:

The tricky part is retaining the original order of fields while inserting missing ageing groups. This should be a dynamic solution even if the ageing groups change. If the ageing groups are always static, then we can take out some of these steps.

If anyone can come up with a simpler solution, I'd love to see it! In the meantime, please let us know if this works for you.

Thanks,

Deb

Juacata_dmd.yxmd