Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
kev6brown
Partner - Creator II
Partner - Creator II

Connector Error

I'm getting the following error - 

kev6brown_0-1760696667332.png

 

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

 

Labels (1)
1 Reply
marcus_sommer

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