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.
I want to export one file for each Category. So the Cat1 file must be in this format:
Cat2 file must be like this
I know I need to transpose the data and export into multiple files. Ideally I should be doing the transpose for each category and then export and go to the next category and so on. Can anyone suggest me how I can do this?
Workflow is attached that can reorient your data as shown below. Then, you can use an Output Data tool to "Take File/Table Name From Field" if you want to dynamically create files from the resulting table.
Gotcha. The other approach would be to turn this workflow into a macro to feed in groups of categories in one at a time which would only output the attribute columns specific to each category rather than all 13,000