Skip to Content
Former Member
Oct 13, 2016 at 09:19 PM

Check Combination of columns with excel spreadsheet



I have 3 column coming from universe and an exel sheet as another data provider. Requirement is to flag the record as 1 if it matches or 3 if it doesn't match.

I've created 3 merged dimensions for 3 columns.

But the detail object of the excel data provider displays the universe values. Actually excel doesn't have data for the combination of 3 columns that comessage from the universe.

The excel data actually has N-N-N mapping.

Eg. Empid, deptid, geoid.

1 Empid has N deptI'd and N geoid and vise versa.

Any help will be great full.