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.
Solved! Go to Solution.
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 : )
In sample output file I will lookup on "Comp Code Col" and update Currency Column and Tax owner column
Hi atcodedog05. Thanks for the solution. It really solved my problem.
Happy to help : ) @kumarpritam575
If my response helps please don't forget to mark it as solution.
Cheers and have a nice day!
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!