Add or Remove Columns based on Input Table

[JoseHerrera]

Hi,

I am looking to make a workflow that based on an input table can add or delete columns in the final outputs. The columns may be strings, data or intergers.

Any ideas on how I can start? I already try to use the Dynamic Select tool but I wasn't able to do it.

I am attaching an example of input and what I am expecting as the output. I am hoping I can split the output to 3 different tables.

Thanks for the help

Input Table

Row	A	B	C	D
1	Yes	No	Yes	No
2	No	Yes	No	No
3	No	Yes	Yes	Yes

Outputs

	A	C
1

	B
2

	B	C	D
3

[Qiu]

@JoseHerrera 
Make a simple flow, please give a try and see if this is what you want. If you do, give a mark, thanks.

[TheOC · Accepted solution]

Hi @JoseHerrera 

If i have understood the ask correctly, i have created a batch macro that does this perfectly.

here is the data that is input:

And here what is output, an output file for each row:

in the same format you asked:

Attached is the macro, this is what it looks like:

Now you will have to change the directory of the output file within this macro, and then save it, so your workflow can run it. I currently have it saving to a specific folder on my drive. I did try to have this dynamically, but as the macro is saved elsewhere, the output will just be dynamic to where the macro file is. If this is a requirement for you though, i'm happy to spend some more time looking at it.

Simply import the macro into a workflow, drag your rows of data in to both input streams, and then make sure to set the choose field within the questions tab to row:

Any questions let me know!

[JoseHerrera]

Thanks for your reply, but it is not what I was looking for.

[JoseHerrera]

Thanks for your answer works great