Skip to Content
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.


Ramesh J


image.png (29.0 kB)