Skip to Content
0
Apr 21, 2021 at 06:46 AM

Compare two query to get data

176 Views Last edit Apr 22, 2021 at 02:54 AM 3 rev

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

Attachments

image.png (29.0 kB)