Compare two query to get data

[former_member225386]

Hi All,

I have a requirement to use compare data field between universe and excel to get data in webi.

Query 1(Unv): In this we have Material details and sales date.

Query 2(Excel): In this we have price of that material based on date range

Report table need to be

Material, Sales Date and Price

I have already tried merging Material in both table and create variable to get price, however ended up in datasync error.

So could you please suggest some solution for this.

Thanks!

Regards,
Ramesh J