Match and Remove

Question

Can someone please help me with the below

I am trying to match and remove data.  The data is not exact as the zeros were dropped in one file - see attached.  I need to find the data under "Asset ID" column from "Asset ID2" column and then drop the data on the output

Thank you in advance

Irene

Matching.xlsx

grazitti_sapna · Accepted Answer

@IreneTrieu , Please use the below formula:

padLeft([Asset ID],12,"0"). The 3 argument must be in double quotes.

Sebastiaandb · Accepted Answer

Sorry for not writing the full expression right @IreneTrieu (i just wrote it here without looking in Designer...)! thanks @grazitti_sapna

IreneTrieu · Accepted Answer

Thank you so much for all your help