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

January 2025 Reconciliation - Updated for Alteryx Process.xlsx

Latest Jan Recon.yxmd

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