Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two data sets.
Data Set 1:
ID | Data Field 1
1 | X1
2 | X2
3 | X3
Data Set 2:
ID | Data Field 2
1 | Y1
In QS I am linking the two data sets on Key being the field 'ID'. When I view this in QS I will see as follows.
ID | Data Field 1 | Data Field 2
1 | X1 | Y1
2 | X2 | -
3 | X3 | -
I want to view the records that were present in Data Set 1, but not in Data Set 2. i.e. The result should show.
ID | Data Field 1 | Data Field 2
2 | X2 | -
3 | X3 | -
Is there a way to do it? I have tried the Isnull (Data Field 2) option to set a flag in a new dimension and it does not work. This works in a measure field, but derived Measure fields cannot be filtered. Please let me know if there is a way to do this.
Add a third field to your data sets called source and name the value data set 1 and data set 2 you will then be able to satisfy both your conditions.
Hope this helps
Andy
May be this,
[Data Set 1]:
LOAD * INLINE [
ID,Data Field 1
1,X1
2,X2
3,X3
];
INNER JOIN ([Data Set 1])
Table2:
LOAD * INLINE [
ID,Data Field 1
1,Y1
];
LOAD *,
IF(IsNull(F2),1) AS [NULL FLAG]
RESIDENT
[Data Set 1];
DROP TABLE
[Data Set 1];
SELECT THE DIMENSION,[NULL FLAG ]=1 SHOULD GIVE YOU THE DESIRED RESULT
If i do that it would look like this.
ID | Source
2 | DS1
3 | DS1
What will be the value of Source field for ID: 1?
If I apply filter on Source = DS1 will I get only 2 and 3?