We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

NEED HELP! Trying to combine several lines of data in excel to one line of data...

IsobelTomkinson
5 - Atom

Hi Guys, 

 

I have a data set which lists out issues of an entity horizontally, see my screenshot below:

IsobelTomkinson_1-1630962259057.png

 

I need to transfer this data so that I record all the issues in one line for that one entity and the list out the issues in separate columns, see what I need it to look like below: 

 

IsobelTomkinson_2-1630962321347.png

 

I have also created a mapping of the issues to know which column to put the issue in and  what type of issue to record it as, see mapping screenshot below:  

IsobelTomkinson_3-1630962413657.png

 

How would I be able to get alteryx to read my original data set (screenshot 1) to use the mapping guidance (screenshot 3) to populate an excel to document all the issues in one row but use several columns and map the type (screenshot 2)?

 

Please note this is an example and not a real client, and please also note i have 8000 lines of data to transform into this new format. 

 

Any help would be greatly appreciated. 

 

6 REPLIES 6
ncrlelia
11 - Bolide

Hi @IsobelTomkinson,

 

Please see attached my suggested solution.

 

ncrlelia_0-1630978497155.png

 

Hope it helps.

 

Cheers,

Lelia

IsobelTomkinson
5 - Atom

Hi Thanks for your help - where do I find the 'Replace Underscore' function? 

atcodedog05
22 - Nova
22 - Nova

Hi @IsobelTomkinson 

 

@ncrlelia is using normal Replace() function to replace underscore.

IsobelTomkinson
5 - Atom

Normal Replace function being: 

IsobelTomkinson_0-1631118656023.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @IsobelTomkinson 

 

Replace() function is being used in dynamic rename tool.

 

Workflow:

atcodedog05_0-1631118822892.png

 

Hope this helps : )

 

 

IsobelTomkinson
5 - Atom

Thank you so much, I understand. I am still quite new to Alteryx so might have a few further questions but thank you all!

Labels