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.