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 · Accepted solution]

Hi @shynoby ,

This is a great scenario for parsing data.

I was able to accomplish the requirement by coupling a workflow with a batch macro.

And have provides a configuration option in the workflow to set location and file name

File generator is the batch row which iterates on each column name and pushes it to write the file.

Files generated

Output file looks like.

Workflow is dynamic and can adapt to changing Y positions.

I hope this helps your purpose. If there is still anything specific you are looking for please reply back.

If it solves your case study please like the reply and mark the reply as accept solution.

PS: really appreciate that you were able to provide the file or else it would have been harder to provide solution.

Thank you for sharing this scenario. It was a great exposure.

Happy Analyzing : )

[shynoby]

Thank you very much for the solution; however, I couldn't open the file and this error popped up:

"Failure to Import C:\Users\vul\Desktop\Alteryx\Parcing\Find and Allocate.yxzp.
There was an error opening "C:\Users\vul\Desktop\Alteryx\Parcing\Find and Allocate\Find and Allocate.yxmd":

This workflow was created by a more recent version of Alteryx, and may contain tools or functionality not present in this version. Alteryx does not support using an earlier version of Alteryx to open a workflow created with a newer version. For best results, download the latest version of Alteryx.

Do you still want to attempt to open the workflow?"

I tried to update my version of Alteryx, but it said mine is up to date. How can I open it?

Thanks again for your time!

[atcodedog05]

Hi @shynoby ,

This is the version i am using.

I haven't faced any versioning issues before.

And it is using all simple tools you should not be getting a versioning issue.

Please check with this file again. Please share a snap of issue you are facing.

Or else share me a blank workflow (.yxmd) file i would load the workflow on it.

[atcodedog05]

Hi @shynoby ,

If you are getting the below highlighted message.

Try giving yes and checking.

[shynoby]

Mine is way older. I did hit Yes but nothing happened. Blank workflow is also attached.

And the snap of error:

[atcodedog05]

Can you try by clicking ok and proceeding.

[shynoby]

I did hit OK but nothing import. Just blank workflow.

[atcodedog05]

Hi @shynoby ,

Try this one.

I have loaded the workflow.

[shynoby]

I can open it this time. Everything seems perfect until the file Generator. It is cut-off and your File Generator has two inputs from Summarized and Join. But mine look like one input and one output- How can I fix that?