Data Investigation

Simon1187

Hi everyone. 

I hope you are well. 

I want to check phone number in two tables and both table has three tables but in a row  the phone number in different columns . I want to check that  in each row all phone numbers are there and if phone number s are not then show me which one was not in a row. 

I really appreciate your help. 

Thanks, 

Simon 

Table A.xlsx

Table B.xlsx

AkimasaKajitani

Hi @Simon1187 

I may not understand what you need.

I transpose all fields to one field at 2 tables and compare the phone no. 

Upper Browse tool shows the phone number that exist in Table A but not exist in Table B.

Lower Browse tool shows the phone number that exist in Table B but not exist in Table A.

Please refer attached workflow.

If you have any questions, let me know.

PhoneNo_AK.yxzp