Extracting keywords from a column, v-lookup function and combining data of 2 column in 3rd

Hello Team, I am very new to alteryx workflow design and I am stuck in process.

1. In the above dataset in description column I have to look for 3 keywords Depr or Depreciation, Interest Income and Interest Expense replace null values in Category column with Deprecation, Interest Income and Interest Expense and keep all other fields blank.

2. Once above step is done I have to combine data of Category Column and Comp Code Column without an space in join column without affecting original data.

3. After that I have to fill Currency and Tax owner column using a function similar to v-lookup in excel with the help of another input file (below screenshot) and the lookup reference will be comp code col.

Can someone please help me with the process.

Workflow

Accepted answers

atcodedog05

Hi @kumarpritam575

Here is how you can do it.

Workflow:

Hope this helps : )

vlookup.yxmd

All comments

atcodedog05

Hi @kumarpritam575

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

kumarpritam575

Hello atcodedog05, I have attached sample input and output files.

Input File.xlsx

Output File & Vlookup reference.xlsx

atcodedog05

Hi @kumarpritam575

Which is the lookup table?

kumarpritam575

In sample output file I will lookup on "Comp Code Col" and update Currency Column and Tax owner column

atcodedog05

Hi @kumarpritam575

Here is how you can do it.

Workflow:

Hope this helps : )

vlookup.yxmd

kumarpritam575

Hi atcodedog05. Thanks for the solution. It really solved my problem.

NatashaSuello

Hi! Glad I found this and this one helps. I have a question though, I have a process where I need to lookup the keywords using the same input file, and the values are also stored in another file just like the example above. Basically, I'd like to repeat the process but for different columns. How can I achieve this?

I have done it for the first column and I want to do the same for the next 3 columns which have specific keywords as well

and place the values in the highlighted columns (same with the first column)

And the values should be from the Base Price.

TIA!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703