Mapping two columns in different files with specific filter

[sriniprad08]

Hi Team,

Hope you are well.

I need help.

Questions - I have two inputs "L1" and "L2". Please find attached. 

Desired output  -  A new column with indicator - If all values listed "L1" in the First input are correctly categorised as Type = “B” in "L2" of the second file,

For e.g. in this example marked in "Yellow" are correctly classified and in "Red" are not correctly classified

Please let me know how to go about this,

Thanks,

Sri

[IraWatt]

Hey @sriniprad08,

What do you want to do if L1 doesn't have a matching L2?

[binuacs]

@sriniprad08 not sure I understand your requirement properly, based on my understanding I think the find and replace would work in this situation

[sriniprad08]

Hi @IraWatt ,

Thank  you for the help. Sorry if i am not clear in my request. 

I wanted a new column called "Indicator"  which says "1" if  the value in "L1" is present in "L2" and the "Type" = B  and "0" if its not present.

For e.g like this below

[IraWatt · Accepted solution]

No worries @sriniprad08,

I've adapted mine:

Let me know if threes any issues 

[binuacs · Accepted solution]

@sriniprad08 Updated the workflow based on your requirement

[sriniprad08]

Hi @IraWatt ,

Thank you so much for the kind reply. Really appreciate it . I will try and get back to you.

Cheers,

Sri

[sriniprad08]

Hi @binuacs ,

Thank you so much for the kind reply. Really appreciate it . I will try and get back to you.

Cheers,

Sr