Hi All,
Hope you are doing well.
I want to understand is there a way where from a Union tool which gives a list of output which has different products lets say A, B, C so on and so forth. How can I segregate these different products in one out file on separate tabs.
Thanks
Solved! Go to Solution.
Hi @mihir_mir_jb,
It is important to have the desired sheet names unioned underneath each other.
This field can be used in the output tool to create different sheets, using the following option:
You click the checkbox and are able to append suffeix to file/table Name.
It even offers you the opportunity to exclude the field from the output.
Kind regards,
Yalmar
Like @yalmar_m mentioned, you can use the Output tool feature to modify the file path. I typically recommend creating the output path for each record ahead of time and replace the entire path in the Output tool option. The "OutputByName.yxmd" attached below will show an example of this in action.
If you are adding new sheets to an existing file, check the Output options to make sure you're replacing only the sheets you specify and not the entire file (which would erase preexisting sheets).
If you'd like to use the reporting tools to add formatting to your output, this is still possible with a few more steps. The "RenderNamedSheets.yxmd" example will show how to achieve that.
Thank you both for your help on this, much appreciated.
Stay safe, take care!