Merged Excel query

[Former Member]

I have a Universe query and an Excel query.

The Universe query contains 5 weeks of data while the Excel query contains a full year.

I need to have the data merged on the Week End Date, among other dimensions and when I use the Week End Date from the Universe query I'm able to only show the counts from the 5 weeks of Universe data. I need to be able to remove the Week End Date and show the counts from the Excel file for just the 5 weeks from Universe query.

I have tried ForEach([Week End Date]) but haven't had any success. Is there another way to accomplish this?

[amitrathi239]

in the webi document summary check the option "extended merge dimension" and try.