3 diffrent dataset to 3 tabs in one csv file

[Borisham]

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

[mceleavey · Accepted solution]

Hi @Borisham ,

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

M.

[Ben_H]

Hi @Borisham 

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

Regards,

Ben

[MarqueeCrew]

@mceleavey ,

You spotted the trick question!  

Nice reply.

[atcodedog05]

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