Mapping two columns in different files with specific filter

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

Alt_que_514.xlsx

Datasets

Tips and Tricks

Transformation

Data Investigation

Accepted answers

IraWatt

No worries @sriniprad08,

I've adapted mine:

Let me know if threes any issues

L1 and L2.yxmd

binu_acs

@sriniprad08 Updated the workflow based on your requirement

Mapping_14_05.yxmd

All comments

IraWatt

Hey @sriniprad08,

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

L1 and L2.yxmd

binu_acs

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

Mapping_14_05.yxmd

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

No worries @sriniprad08,

I've adapted mine:

Let me know if threes any issues

L1 and L2.yxmd

binu_acs

@sriniprad08 Updated the workflow based on your requirement

Mapping_14_05.yxmd

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 @binu_acs ,

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

Cheers,

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335