I have noticed that only the first table listed of the two below will load (according to the Table Viewer). If I change the order the other table will show in the Table Viewer while the other will not. I suppose the tables must be loading somewhat since the CommentType is available for both types in the project itself.
*********************************************************************************************************************
DEMOGRAPHICS:
LOAD SERVICE,
VARNAME,
'DEMOGRAPHICS' As CommentType,
QUESTION_TEXT,
VALUE,
%Key_PATIENTLEVELDATA_E1A59225A73AF151
FROM $(DEMOGRAPHICS) (qvd);
ANALYSIS:
LOAD SERVICE,
VARNAME,
'ANALYSIS' As CommentType,
QUESTION_TEXT,
VALUE,
%Key_PATIENTLEVELDATA_E1A59225A73AF151
FROM $(ANALYSIS) (qvd);
*********************************************************************************************************************
I wouldn't think that it should matter how I create the QVD files but I've included that as well.
What I'm really trying to do is isolate the cause of inconsistencies in one of my expressions and right now I'm looking at either a flaw in how I create the QVD or how I load the QVD. Considering that there are tables missing from the Table Viewer that I expect to be there I'm starting there. Is this expected behavior?
*********************************************************************************************************************
ANALYSIS:
LOAD SERVICE,
VARNAME,
'ANALYSIS' As CommentType,
QUESTION_TEXT,
%Key_HEADER_8B8B72D6FCC98357 // Key to parent table: DATA_EXPORT/HEADER
FROM $(FILE) (XmlSimple, Table is [DATA_EXPORT/HEADER/QUESTION_MAP/QUESTION]);
Join (ANALYSIS)
LOAD VARNAME,
'ANALYSIS' As CommentType,
VALUE,
%Key_PATIENTLEVELDATA_E1A59225A73AF151 // Key to parent table: DATA_EXPORT/PATIENTLEVELDATA
FROM $(FILE) (XmlSimple, Table is [DATA_EXPORT/PATIENTLEVELDATA/ANALYSIS/RESPONSE]);
STORE ANALYSIS INTO ANALYSIS_13.QVD;
DEMOGRAPHICS:
LOAD SERVICE,
VARNAME,
'DEMOGRAPHICS' As CommentType,
QUESTION_TEXT,
%Key_HEADER_8B8B72D6FCC98357 // Key to parent table: DATA_EXPORT/HEADER
FROM $(FILE) (XmlSimple, Table is [DATA_EXPORT/HEADER/QUESTION_MAP/QUESTION]);
Join (DEMOGRAPHICS)
LOAD VARNAME,
'DEMOGRAPHICS' As CommentType,
VALUE,
%Key_PATIENTLEVELDATA_E1A59225A73AF151 // Key to parent table: DATA_EXPORT/PATIENTLEVELDATA
FROM $(FILE) (XmlSimple, Table is [DATA_EXPORT/PATIENTLEVELDATA/DEMOGRAPHICS/RESPONSE]);
STORE DEMOGRAPHICS INTO DEMOGRAPHICS_13.QVD;
*********************************************************************************************************************
