Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am combining the two tables below, and linking it to a third table.
The two tables has a field I created in the load call Measure.
1. 'ProfileOnly' as Measure,
2. 'NewRx' as Measure,
The third table does not have this field.
How can I populate the null cell below with the word Delete?
In my pivot table see the blank cell above NewRX.
DATA LOAD
LIB CONNECT TO 'pharmoresql |
LOAD FacID, |
'0' as TransType, |
ProfileOnly as Type, |
'ProfileOnly' as Measure, |
eRxMsgID; |
SQL SELECT FacID, |
ProfileOnly, |
eRxMsgID |
FROM Pat.dbo.Reorders |
Where ProfileOnly <> '0'; |
LOAD |
FacID, |
TransType, |
NewRx as Type, |
'NewRx' as Measure, |
eRxMsgID; |
SQL SELECT NewRx, |
TransType, |
FacID, |
eRxMsgID |
FROM Rx.dbo.HRxs |
Where NewRx <> '0' |
and TransType <> 'Q' |
and TransType <> 'R'; |
Hi Robert, those records seems the ones that has no relation with the values loaded in the queries, you can change this in script but you'll need to prive more info about the first dimension and the rest or model.
Other easy solution can be using a calculated dimension for Measure:
If(IsNull(Measure), 'Delete', Measure)
in the script for the third table just put in a line of code:
"Delete" as 'Measure',
I tried that and it removes the other two cell names.
Hi Robert, those records seems the ones that has no relation with the values loaded in the queries, you can change this in script but you'll need to prive more info about the first dimension and the rest or model.
Other easy solution can be using a calculated dimension for Measure:
If(IsNull(Measure), 'Delete', Measure)