topic Re: Generate Tabs in existing excel file with specific field in Alteryx Designer Desktop Discussions

Generate Tabs in existing excel file with specific field

Learner09 — Mon, 13 May 2024 11:27:31 GMT

Hello,

I am managing a folder containing over 100 files, each with distinct filenames. While the files vary in content, they all contain a column labeled "city." I am tasked with creating a process, be it a macro or a workflow, that navigates through each file, extracts the city data, and generates tabs based on the unique city names found within each file.

For instance, let's consider a file named "2550-AB." The process would delve into this file, identify the city column, and partition the data into tabs corresponding to the distinct city names present in the file. In the case of "2550-AB," which contains records for Moscow, Nampa, and some with blank entries in the city column, the resulting tabs would be "Moscow," "Nampa," and "Blank," each housing data pertinent to its respective city.

I've attached a file to provide a clearer understanding of the task at hand. Any guidance or assistance in devising this macro or workflow would be greatly appreciated

Re: Generate Tabs in existing excel file with specific field

binu_acs — Mon, 13 May 2024 11:39:05 GMT

@Learner09 what would be the output file names for each of the above files? keep the same name with different tabs for each city?

Re: Generate Tabs in existing excel file with specific field

Learner09 — Mon, 13 May 2024 11:45:28 GMT

@binu_acs yes file names should be the same with adding new tabs with city names and consist data according to the cities.

Re: Generate Tabs in existing excel file with specific field

binu_acs — Mon, 13 May 2024 11:52:16 GMT

@Learner09 The attached workflow writes all the output to a seperate a folder named output with the same input file name

Re: Generate Tabs in existing excel file with specific field

Learner09 — Mon, 13 May 2024 12:26:20 GMT

@binu_acs it kicks off the error at the output tool

Re: Generate Tabs in existing excel file with specific field

binu_acs — Mon, 13 May 2024 12:50:12 GMT

@Learner09 can you try now

Re: Generate Tabs in existing excel file with specific field

Learner09 — Mon, 13 May 2024 13:09:42 GMT

@binu_acs Thank you, I fixed the previous one, and now it working!