Hi Team,
I have 2 reports with different data and want to merge the reports. I can understand that with 'contains' formula we can get the result. However, for large data set contains formula will not be feasible. Please let me know if there is any other approach for the same.
Report 1:
Description |
ABC USA |
ABC France |
ABC CanadaLtd |
ABC Canada |
ABC Australia |
ABC Brazil |
Report 2:
Country |
USA |
Australia |
Canada |
Netherlands |
Output:
Country | Description |
USA | ABC USA |
Australia | ABC Australia |
Canada | ABC CanadaLtd |
Canada | ABC Canada |
Netherlands | NIL |
Regards,
Shikha
Solved! Go to Solution.
Hi @sshivani I mocked up a workflow that produces your output let me know what you think?
Hi @sshivani ,
please find my approach attached:
Is this the solution you were looking for?
Best regards
Phil
Thanks for your help.
Regards,
Shikha
Thanks for you help.
Regards,
Shikha