Merge two reports

[sshivani]

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

[JosephSerpis]

Hi @sshivani I mocked up a workflow that produces your output let me know what you think?

[PhilippK · Accepted solution]

Hi @sshivani ,

please find my approach attached:

 

Is this the solution you were looking for?

Best regards

Phil

[sshivani]

Thanks for your help.

Regards,

Shikha

[sshivani]

Thanks for you help.

Regards,

Shikha