Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm getting the following error -
From my script
ConRepDimension:
LOAD * INLINE [
_ConRepDimension
MRN
NHS Number
Spell Number
Consultant
HRG Code
HRG Code Name
POD
EpiSer
TFC
TFC Name
Episode Start Date
Episode End Date
Age in Years
Age in Range Bands
1st Procedure
1st Procedure Name
1st Diagnosis
1st Diagnosis Name
Admission Date
Discharge Date
Local Episode Number
Financial Period
Episode Number
Unique ID
ClinicCode
Site
CCG Code
CCG Description
Epinum
Discharge Month
Directorate
MRSA Flag
CDIFF Flag
Diabetes Flag
NHS Flag
Dominant Procedure
$(vUSERDEF1LOCALNAME)
$(vUSERDEF2LOCALNAME)
$(vUSERDEF3LOCALNAME)
$(vUSERDEF4LOCALNAME)
$(vUSERDEF5LOCALNAME)
$(vUSERDEF6LOCALNAME)
$(vUSERDEF7LOCALNAME)
$(vUSERDEF8LOCALNAME)
$(vUSERDEF9LOCALNAME)
$(vUSERDEF10LOCALNAME)
];
OpBoard where the script is falling over is in the variable - $(vUSERDEF5LOCALNAME)
The first 4 load so why not the 5th?
Thanks
Kev
It looked that your variable contain the chars [ and ] which are conflicting with the inline-load delimiter which are also [ and ].
Possible solutions may be to remove the square brackets or adding an appropriate masking of [[ respectively doubling them or choosing another inline-load delimiter respectively field-name wrapping which could be: [ ] or " " or ` `. See also: QlikView Quoteology - Qlik Community - 1476029