Add fields to an input that hasn't happened yet

cam_delavedua

Hi! I'm working on a workflow that depends on months of the FY. We start on July '23 and finish on June '24. The input brings hours worked per week, that was grouped by month. But as the input brings until the last available date, I need a second input that would add the fields from the months that haven't happened yet, and mark them as 0 (as no hours were worked). But next month when they add the hours from it, the hardcoded input won't overwrite. I need that it shows 0 but as soon as the new input has values, to start showing those values in their respective fields. 

This table shows how it should look

And this is my WF now

Raj

@cam_delavedua 
you have the data updated every month 
what i suggested is first by the transformation you Create the data for all the available months 
then using a text input tool create all the 12 months as headers
once you union them you will find the extra columns with no entry as null then you can do the final step either way suggested above

if you have still any queries add some sample data will help with the flow.