Date Value missing data

[Tanai_Goncalves]

Hello all,

I'm having a problem to append missing data on a day by day basis, joining multiple tables.

I wish to have values for all days of the year, and when a field don't have values on that date I'll use the data from the previous day. But I have different products and different categories, and I can't link each category to it's previous day value.

See on the sheet attached, My main problem its the data on the headers named item and color from table 2.

Any ideas?

Thanks in advance.

Tanai

[jdunkerley79 · Accepted solution]

I suggest the following:

First, make list of all items and colours.

Next make a list of all dates

Use an append fields tool to 'cartesian join' these. Make sure it is set on 'Allow all appends'.

You can then join the input data onto this to get the Value table values

Some rows will be joined and some will be on the Left output, so need to union  to make a single table

After this you can sort and then use Multi Rows to fill in gaps

Sample attached

[Tanai_Goncalves]

Thank you!!

I was trying something similar.

But the 'allow all appends' were the key.

Best regards

Tanai

[Tanai_Goncalves]

Thank you!!

I was trying something similar.

But the 'allow all appends' were the key.

Best regards

Tanai