Matching id with ignoring 1 character

im sorry it’s confidential.

the dt1 is .csv and the dt2 is .xlsx

but i manually checked both files. the ids are there. :frowning:

im having a hard time. cause some of my process is matching id. i’ve been stock in this issue since last week huhu.