Multiple Outputs

[wcamarg3]

Hi all,

I have a table like this, and I would like to generate a multiple "csv" file output with the headers name.

These headers name are dynamic, it varies according to the data.

These columns names are dynamic -->	A_ONE OP10	A_ONE OP20	B_ONE OP20	B_TWO OP30	C_ONE OP40
	1	2	123	145	789
	2	5	157	246	654
	3	4	256	254	123
	4	7	249	245	789
	5	8	210		120
		9	350
			370

Basically for this examples I would like files named like:

A_ONE OP10.csv (The content is the column data)

A_ONE OP20.csv (The content is the column data)

B_ONE OP20.csv (The content is the column data)

B_TWO OP30.csv (The content is the column data)

C_ONE OP40.csv (The content is the column data)

Many thanks,

Wilson

[AngelosPachis · Accepted solution]

Hi @wcamarg3 ,

You will probably going to need a batch macro for this task. Your workflow will have to include a Fields Info tool that will give you a list of all column headers (column [Name], which you will then feed to the control parameter of your batch macro.

Your batch macro, will then run for each one of those column headers. From your table, the dynamic select tool is going to select each column one by one and then create a single output for each one of them

The output is going to look something like this:

where each file contains only the corresponding column

Hope that helps,

Angelos

[wcamarg3 · Accepted solution]

I @AngelosPachis . I downloaded your macro, but what is the command you used? It seems to me a "?", but on the screen shot you share is a "blue circle". Which command I can use?

[wcamarg3 · Accepted solution]

Here is how it came to me!

[atcodedog05 · Accepted solution]

Hi @wcamarg3 

There is a possibility that you are using lower version of Alteryx which is causing the break. You can use this guide to downgrade the packaged workflow.

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/...

Hope this helps : )

[AngelosPachis · Accepted solution]

Hey @wcamarg3 ,

Do you mind giving it a second try? I thought I fixed the workflow dependencies, but I might be mistaken.

@atcodedog05 suggestion is also valid, but just in case I'm also sending over the workflow and batch macro separately. You just have to downgrade them and keep them in the same directory for the workflow to work

[wcamarg3]

Thank you @AngelosPachis ! It was the solution to my problem!

[wcamarg3]

Thank you @atcodedog05  ! I had a version isso, and this article help me solve the problem!

[atcodedog05]

Happy to help : ) @wcamarg3 

Cheers and have a nice day!