This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Right now I am trying to export each unique entity id as it own excel sheet with each excel sheet have 3 tabs with different information (meaning if I have 7 unique entity ids then I should get 7 excel workbooks each workbook with 3 tabs); whats the best way to do this?
The attached workflow will show you how to achieve this. The first portion of the workflow that I have placed into a container is where you will need to build in your own logic which determines which ID's go to which files and tabs - I have just created this for a sample.
The Formula tool after the Join is then used to build the logic for a filepath for each record in your data. Then in the final output you are then changing the output based on this entire full path.
You will of course need to update the folder destinations as well when building this for your work.
Let me know if you have any questions on the above.