i Team,
Can someone please help with the below ?
So I need my output to have different tabs output?
Solved! Go to Solution.
Hey @zkhadi
You need to first build a formula that sets the full file path and the sheet name that you wish to save:
Then configure your output tool to "change entire file path"
There's not really enough information here, but you can generate multiple outputs by using the "Take File/Table Name From Field" option, and selecting the field that would determine the split:
This is often used for splitting out records into multiple files by date or date ranges.
Let me know if this is what you're after.
M
Hey thanks ! this worked.
But pls can I ask how did you get the sheet option there?
Hi @zkhadi,
In @LordNeilLord's example you would create a field, in this case named "Sheet" using whatever logic would determine the split. For example, if the sheets are split by month/Year, then create a field showing the month/Year from the date in the data, and use this field. This will then assign the records to the appropriate sheet. As new dates are added, the new records will create a new sheet, and so on.
Hope this helps.
Thanks understood worked !