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

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.

Input data.xlsx

Output consolidated.xlsx

Workflow

Datasets

Output

Transformation

Dynamic Processing

Documentation

Accepted answers

All comments

caltang

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

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.

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.

E&I.yxmd

@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...

E&I.yxzp

caltang

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

@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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703