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

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

example.yxzp