I want to populate the Above row 1 dates as Field or Headers in the Yellow marked row 11. Basically these are 2 tables unioned but also for the blank or null Cells in Row 11 the above dates needs to be populated .
They are joined by (Auto configure by Name) that's why the dates which are not common and is not there in The Table 2 for those the headers are coming as blanks. Any suggestions how this can be done.
Screenshot attached ( Fields populate.PNG)
So basically I have two tables I want to union Them one above the other. But the challenge is all the field names (DAte Fields) in Table 1 is not there in Table 2. The one those are common I have stacked them and the header is showing up in Row 11 as given. But beside that you can see (Yellow Marked) rows are blank. Those needs to be filled up from the above date Headers.
Can you share sample input files ?
Why do you need to repeat the headers within the data ? Isn't it enough to have the headers then union only data ?
No the requirement is such that the Headers are required to be repeated as the two tables are different. Also not all the fields are present in table 2 so for those the headers shall come up and the data would be 0. This is required for a comparison of the hours
Unfortunately I can't think of a simple solution for your problem. Maybe @atcodedog05 or @Emil_Kos can think of something !
Hi @Jean-Balteryx,
Thank you for shouting out. I created a solution maybe not the most elegant one but it works.
Hi @DataPirate26,
Please see the workflow attached:
And the output:
Thank you for posting. But actually i need the headers to replicate for table 2 also. The solution which you have given I already have came to that. I am attaching the solution which I have got.
I want those above dates to also populate in those yellow arked fields. That is the desired output I am looking for.