Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Complex String Manipulation - Multiple Excel Table Creation from - Single File

sriniprad08
11 - Bolide

Hi Team,

Good morning. Hope you are well. I have task which i need help.

 

Task 1 -

 

I have three files 

A) input file

B) Mapping file

c) Example - Output File - Part 1

 

Objective -

a) Map the Input file and Mapping file and Bring the column "B" from Input file to the Mapping file.

b) Next step create the separate tab for each item in "Quiz Question Name".

 

Please find attached the Example - Output File Part 1

 

Task 2

a) Using the same Final output file from above task Separate the column "Quiz Response" into "Review" and "Non_Review" and concatenate the results into single row by user and semicolon

 

Please let me know your thoughts,

 

Thanks

SR

 

 

8 REPLIES 8
ChrisTX
15 - Aurora

Can you post your workflow?  Is there something that's not working? 

 

If you just don't know where to start, try:

Learn > Academy > Learning Paths

Learn > Academy > Interactive Lessons

 

At a minimum, you could use two Input Data tools and a Join tool.

 

Chris

Adrian_T
Alteryx
Alteryx

Hey @sriniprad08,

 

Here's one way of doing this. Depending on what you would like to see as the output of Part 2, go ahead to amend the final Select Tool before the Output Data Tool.

 

Adrian_T_0-1669895305883.png

 

sriniprad08
11 - Bolide

Hi @Adrian_T ,

 

Thank you so much for your time. Looks great. 

Can i ask one question please?

 How can i output the final data in the below format split into different sheets by "Quiz Question Name".

 

Cheers

Sri

 

sriniprad08_0-1669896923293.png

 

Adrian_T
Alteryx
Alteryx

Hi @sriniprad08,

 

This was achieved by configuring the Output Data Tool under "Take File/Table Name From Field" as shown below. Hope this helps! 😎

 

Adrian_T_0-1669897293472.png

 

 

sriniprad08
11 - Bolide

Thank you :) @Adrian_T . Couple of clarification, there are blanks for Due Diligence Red Flags II there is a value in the original data.

Can we have the original text retained if there is no Review or Non Review please?

 

Thank for the help.

 

 

sriniprad08_1-1669907482043.png

 

sriniprad08_2-1669907504014.png

 

 

 

 

 

 

Adrian_T
Alteryx
Alteryx

Hey @sriniprad08, yes that’s possible. In the Select Tool under the “Part 2” Container, go ahead to check the column [Quiz Responses]. 

sriniprad08
11 - Bolide

Hi @Adrian_T ,

 

Thank you so much for the great help. I will get back to you incase of any questions.

 

Cheers,

Sri

sriniprad08
11 - Bolide

Hi @Adrian_T ,

Hope you are doing well. Can you please help me with one more thing, 

Please find attached the pics,

 

1) In the first one anything after - Report1_Report3_ should be removed. I have marked as current state and "new" one. - For the FACILITY RANKING

2) In the second one anything before the ._storage management should be retained. - INSPECTION_EXCERPTS_REPORTS

 

Thanks for the help.

Sri

 

Labels