Matching the Districts Name

Dear all,

I want your help in that. As you can see in the picture below I want to check these two highlighted words with the other excel sheet attached with the name of District Normalized on xName column so, the word which is matched between these two highlighted words in any cell in the xName column should be written in the new column next to the shipping address with a column title of District Name, and the cell which is empty like row 5 should take the same district name of the previous one. For example the cell in the row 11 should be filled by the same district name of row 10.

I hope my explanation is clear.

DistrictsNormlized.xlsx

Accepted answers

Bennel_Wilson

Hi @Feras95p ,

Let me know if this works. I did try some google translate to verify the output. Nevertheless, let me know if this work for your.

Regards,

Benn

P.S: In case this solves your query,kindly mark it as a solution.

District Match.yxmd

District Match.xlsx

All comments

Bennel_Wilson

Hi @Feras95p ,

Although, I don't understand the language at all, I'll need the file with the shipping address column as well to help draw a workflow. Would you be able to share that as well.

Regards

Benn

Feras95p

Here it is

Sample.xlsx

Feras95p

Hi @Bennel_Wilson ,

What I’m looking for is that, I want to check the shipping address with the xName that’s found in other file attached named by NormalizedDistrct. So I want to have a workflow that is checking row by row the shipping address matching with the districts names in the Xname column so the matched district name between these two files should be written in a new column next to the shipping address.

The other thing is that, I want the empty rows in the shipping address column to be filled by the previous row.

I hope now it’s clear 🙏🏻

Bennel_Wilson

Hi @Feras95p ,

Let me know if this works. I did try some google translate to verify the output. Nevertheless, let me know if this work for your.

Regards,

Benn

P.S: In case this solves your query,kindly mark it as a solution.

District Match.yxmd

District Match.xlsx

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280