community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How to add values to a column from another table

Meteoroid

Hi, I have been trying to give some values to a column comparing another column with a table on another excel file. Example:

 

This two are the original excel files:

Untitled.jpgUntitled2.jpg

 

This is what i am looking forward to have.

Untitled3.jpg

 

I have been watching tutorials and lots of themes here and i cannot finde anything.

 

Could anyone help me?

 

Thanks!!

Alteryx Certified Partner
Alteryx Certified Partner

There's a relatively straight forward solution to this.

 

2018-04-10_16-29-41.png


Start by recordID'ing your data. Then pivot your PR values around this record ID (ignore the V columns).

This will give us something like...

IDNameValue
1PR1A
1PR2E
1PR3F
2PR1A
2PR2E
2PR3F


We can then perform a join against our 2nd table connecting the 'Value' column to the 'Products' column of our 2nd table. This will give us the result...

IDNameValueRight_Value
1PR1A2
1PR2E6
1PR3F7
2PR1A2
2PR2E6
2PR3F7


We can then parse out the digits from our name column, then use a formula tool to prefix this number with the value V.

We can then perform a cross-tab before joinging our data back with the original table.

Example attached.

Ben

Alteryx Certified Partner

Hey @lacubata

 

I'd go for something like this:

 

CrossTabs.PNG@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Labels