Find and replace not working

[Amy123]

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

[atcodedog05]

Hi @Amy123 

Can you provide this in an excel file. What columns are you doing vlookup on and provide with sample output.

[mceleavey]

Hi @Amy123

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.

[Amy123]

Hi @atcodedog05 

Attached sheet.

I want to perform a vlookup on CD to bring the status column value based on Concatenate Order + Segment.

thanks

[atcodedog05]

Hi @Amy123 

Here is how you can do it. Refer the highlighted configurations.

Workflow:

Hope this helps : )

[Amy123]

Hi @atcodedog05 

 The output is not correct. the correct status column should be:-

Segment	Order Number	Concatenate Order +Segment	Balance	Status
1234		1234_	15000	Open
1234		1234_	15000	Open
1234		1234_	20000	Open
1234		1234_	-100	Closed
1234		1234_	-100	Closed
1234		1234_	-32	Closed
1234	333333	1234_333333	25	Open
1234	333333	1234_333333	25	Open
1234	333333	1234_333333	25	Open
1234	333333	1234_333333	25	Open

Thanks

[atcodedog05]

Hi @Amy123 

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.

Hope this helps : )

[Amy123]

Hi @atcodedog05 

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..

Thanks

[atcodedog05]

@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.

[Amy123]

Hi @atcodedog05  

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 

Status	Status2
Open	Deleted
Open
Closed
Pending