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 

[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.

[Simon1187]

Hi AkimasaKajitani, 

Thank you very much for your help. 

Could you please help me how I can put the data in the cell that are not in that table. 

Thanks,

Simon

[AkimasaKajitani]

Hi @Simon1187 

I added the integration of table A and B to the workflow.

Prerequisite is the following.
- Record position is based by Table B.
- All phone numbers are integrated from Table A and B.

Please refer attached workflow.

[Simon1187]

 Hi @AkimasaKajitani 

Thank you very much.

Thanks,

Simon