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.
解決済! 解決策の投稿を見る。
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
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 🙏🏻
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.