Skip to Content
0

Check Combination of columns with excel spreadsheet

Oct 13, 2016 at 09:19 PM

26

avatar image

Hi,

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers