new column for Vlookup using Join

[SashaAmerican]

Greetings Alteryx Family,

I am attaching two files, the first is my excel spreadsheet and the second is my Alteryx workflow. As you can see I started building the workflow in Alteryx I am on column "BP", and "BQ" how can i add an additional columns using the join tool for Vlookups? I know to add a column you would use a formula tool and add column. However, when doing a Vlookup you use the join tool but there are no additional columns to name matching "BP" and "BQ" need to name two columns the vlookup title but need assistance making the columns match the excel....STUCK ON VLOOKUP PORTION

[DanM]

@SashaAmerican 

Based on the Join tool configuration, the join you created does work BT concatenate and the Concatenate trn Inc, etc. joins just using that join in the tool. When you add the second portion you are using the same first field but a different second field. Those two fields have different formats. Alteryx doesn't use a "contains' type setup in the join tool. Without understanding the data, it looks like you may need to parse the BT column to then match the format of the trn inc column.

Hope that helps.

DanM