3 diffrent dataset to 3 tabs in one csv file

Hello,

I filter my data into 3 sections (low, medium, high), this field called Level

After filtering to 3 levels (low, medium, high), I would like to write this into 3 tabs on the same CSV file. How can I achieve this?

This workflow will run daily.
The tabs name will have a different name (low = 'level 1', medium = 'level 2', high = 'level 3' )

Thanks

Datasets

Accepted answers

.csv files don't have tabs, so that would be impossible. You would need to write it out to Excel.

To do this in Excel you will need to write a formula to create the filepath for the records, each one with the difficulty as the tab:

"<filepath>"+Filename+".xlsx"+"|||"+[Difficulty]

Then use this as the output path in the output tool:

Hope this helps.

.csv files don't have tabs, so that would be impossible. You would need to write it out to Excel.

To do this in Excel you will need to write a formula to create the filepath for the records, each one with the difficulty as the tab:

"<filepath>"+Filename+".xlsx"+"|||"+[Difficulty]

Then use this as the output path in the output tool:

Hope this helps.

CSV files don't support tabs, you could output to an XLSX instead.

Regards,

Ben

You spotted the trick question!

Nice reply.

Even i had the same thought that .csv cannot have tabs. Then i was like can it 🤔 ? waiting for someone to make it happen 😅