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

Date Appending.xlsx

jdunkerley79

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

Fill in dates by item.yxmd