Convert a Un customized data to a report that can append data to maintain daily record

[DD]

To create a workflow which can take the uncleaned/clustered data set and performs a transformation to clean the data set to provide an output containing historical output and to append data with ongoing daily records.

Attached both Input data set and expected required output results.  

[caltang]

So... you expect someone to build it for you?

[DD]

Nope, I have built a workflow using this data. However i am not able to fetch historical records 

[caltang]

Attach your workflow here and tell us where you are stuck and what you have tried, then I think we can better advise / help.

[DD]

Attaching my workflow, where i am able to create the data for single day. However, when i bulk data is pulled my workflow fails due to select records tool as the row numbers gets changed and data is unorganized. 

Need help to append historical records and daily records. 

[DD]

@caltang I have attached my workflow, the workflow can be used for daily append data but cannot write historical. 

I am able to bring dates and product but the only challenge I am facing is to write all previous records at once. Any suggestions can you help with after checking my workflow.

[caltang]

Here's how you can get the data from other sheets into one...

[caltang]

Did this help you @DD ? Please mark the post with an accepted solution to close the thread. Thanks!

[DD]

@caltang thanks Caltang. I went through the workflow, thanks for the solution. I have couple of questions here
1) In the output I am unable to find the 'Model' field, which is the main to identify the vehicles basis the categories under each sector i.e Goods or services or Goods+Services 

2) The data sources for the input files are generated on daily basis. 

Output expected