Hi Team,
Can anyone help me how to perform the vlookup on alteryx for attached text file.
I need Status column in Find sheet .
Thanks
Hi @Amy123
Can you provide this in an excel file. What columns are you doing vlookup on and provide with sample output.
vlookup is obviously an Excel function, so can you please describe what you're trying to do?
You've posted an unstructured data source, is this representative of what you have? A text file with no columns? If so, how would you perform a vlookup on this in Excel as there are no column delimiters?
Also, is it a case of you want to treat the first two rows as one data source, and rows 5 to 11 as the second?
M.
Hi @atcodedog05
Attached sheet.
I want to perform a vlookup on CD to bring the status column value based on Concatenate Order + Segment.
thanks
Here is how you can do it. Refer the highlighted configurations.
Workflow:
Hope this helps : )
The output is not correct. the correct status column should be:-
Can you let me know what are the mapping column. And as I can see all negative Balance are closed and all positive Balance are open. You can directly apply a formula.
We can have + ve in Balance as well for closed.
I don't have any mapping. I was not to do it so I check here maybe you can help me with some logic to get the desire output I am looking..
@Amy123
That is important what is logic/criteria for an account to be open or closed. You need to ask in your team/client team around that. If you get the logic let us know we can help you out.
Can you help me how to get the Status Column Values on Status 2 column just for blank Status 2 column I mean it should not replace Status 2 values
Here is how you can do it.
