We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Multilevel data in different columns

MadiNissi
7 - Meteor

Hello,

 

I have a file with eight columns (A to H), each one representing the description of the code in column I. Is there a way to have one column with the respective material description?

 

I am not sure if I was clear but below you can see an example:

- Code 45 has the description in column A

- Code 45,200 to 4511 has the description in column B

- Code 451116 has the description in column C

 

MadiNissi_0-1667333191539.png

 

I am looking for a solution in Alteryx to have two columns: one for the material code and another for the description.

Did anybody work on this before? Would you mind sharing your thoughts?

 

Thank you.

Madi

 

6 REPLIES 6
CarliE
Alteryx Alumni (Retired)

@MadiNissi 

 

Can you send a sample dummy data excel file? and the expected outcome?

Carli
MadiNissi
7 - Meteor

@CarliE - Sure, please find attached the dummy data.

CarliE
Alteryx Alumni (Retired)

@MadiNissi

 

Is this what you are looking for?

CarliE_0-1667335978626.png

Attached is the workflow. I transposed the data, filtered nulls out and ended up like this.

 

If this solved your problem, please make sure to mark it as a solution!

 

Thanks

 

Carli
acarter881
12 - Quasar

Hello @MadiNissi. Here's how to get the exact output you are looking for.

 

acarter881_0-1667341120586.png

 

binuacs
21 - Polaris

@MadiNissi Similar to other solutions

binuacs_0-1667343232689.png

 

MadiNissi
7 - Meteor

Hi - It worked! Thank you for sharing the solution! 😉

Labels
Top Solution Authors