How to add values to a column from another table

[lacubata]

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:

This is what i am looking forward to have.

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

Could anyone help me?

Thanks!!

[BenMoss]

There's a relatively straight forward solution to this.

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...

ID	Name	Value
1	PR1	A
1	PR2	E
1	PR3	F
2	PR1	A
2	PR2	E
2	PR3	F

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...

ID	Name	Value	Right_Value
1	PR1	A	2
1	PR2	E	6
1	PR3	F	7
2	PR1	A	2
2	PR2	E	6
2	PR3	F	7

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

[LordNeilLord · Accepted solution]

Hey @lacubata

I'd go for something like this:

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome