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?
Thanks
Solved! Go to 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.
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 😅