Read "Y" from the columns and print out the whole column to separate file

[shynoby]

Hi all,

I am new to alteryx and really need some help here.

My input is like the picture (I also attached the file). For my output, if line 4 has a "Y", I want to print column ID, Name and column with "Y" out. Each column with "Y" will be printed out separately. So my output should be ID, Name and CA in one file. ID, Name and DC in a separate file. and so on... Thank you very much in advance.

[atcodedog05]

Thats great we are making progress. Let me share one more workflow within 3-4 mins.

[atcodedog05]

Hi @shynoby ,

Thats great we are making progress. You problem is partially solved. It must the versioning issue again.

Try this workflow.

[shynoby]

Same with the older version. Issue with File Generator.

[atcodedog05]

Try this one.

If it doesnt work right click on the macro select open macro and send me a snap of the workflow.

If you could upgrade your Alteryx that would be a faster fix too : )

[shynoby]

Thank you very much for all your help! You are awesome!

[atcodedog05]

Did it work ? as expected ?

Here is the same workflow as analytic app as a backup.

[shynoby]

Yes, it works. Thanks again!

[atcodedog05]

Hi @shynoby ,

You are welcome.

Always happy to help : )

Happy Analyzing : )

It would be a great support to me if you could do me a small favor and like all my replies.

It is going to contribute to my profile : )

Thanks again for sharing this scenario. It was a great learning and exposure : )