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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Aviad2045
Contributor
Contributor

Unexpected token: '',

I am trying to to create new files from exciting filed that look like that: (123,1213,ffgfg,ddw....) - commas between the values

when I loaded from the DB I got this error:

The following error occurred:
Unexpected token: '',
IF(entryKey = '', expected one of: ',', 'AutoGenerate', 'From', 'From_Field', 'Inline', 'Resident', 'Extension', ...

this is my code:

 IF(entryKey = 'IPL',SubField(entryValue,',', 1)) as HeadSN,
IF(entryKey = 'IPL',SubField(entryValue,',', 2)) as Mode,
IF(entryKey = 'IPL',SubField(entryValue,',', 3)) as Application,
IF(entryKey = 'IPL',SubField(entryValue,',', 4)) as PresetType,
IF(entryKey = 'IPL',SubField(entryValue,',', 5)) as SkinType,
IF(entryKey = 'IPL',SubField(entryValue,',', 6)) as CI1,
IF(entryKey = 'IPL',SubField(entryValue,',', 7)) as CI2,
IF(entryKey = 'IPL',SubField(entryValue,',', 8)) as CI3,
IF(entryKey = 'IPL',SubField(entryValue,',', 9)) as Filter,
IF(entryKey = 'IPL',SubField(entryValue,',', 10)) as LightGuide,
IF(entryKey = 'IPL',SubField(entryValue,',', 11)) as Chiller,
IF(entryKey = 'IPL',SubField(entryValue,',', 12)) as PulseType,
IF(entryKey = 'IPL',SubField(entryValue,',', 13)) as T1,
IF(entryKey = 'IPL',SubField(entryValue,',', 14)) as D1,
IF(entryKey = 'IPL',SubField(entryValue,',', 15)) as T2,
IF(entryKey = 'IPL',SubField(entryValue,',', 16)) as D2,
IF(entryKey = 'IPL',SubField(entryValue,',', 17)) as T3,
IF(entryKey = 'IPL',SubField(entryValue, ',', 18)) as Energy,
IF(entryKey = 'IPL',SubField(entryValue, ',', 19)) as Energy1A,
IF(entryKey = 'IPL',SubField(entryValue, ',', 20)) as Energy2A',
IF(entryKey = 'IPL',SubField(entryValue, ',', 21)) as Energy3A,
IF(entryKey = 'IPL',SubField(entryValue, ',', 22)) as Current,
IF(entryKey = 'IPL',SubField(entryValue, ',', 23)) as Current1A,
IF(entryKey = 'IPL',SubField(entryValue, ',', 24)) as Current2A,
IF(entryKey = 'IPL',SubField(entryValue, ',', 25)) as Current3A,
IF(entryKey = 'IPL',SubField(entryValue, ',', 26)) as HeadFactor,
IF(entryKey = 'IPL',SubField(entryValue, ',', 27)) as LastPulses,
IF(entryKey = 'IPL',SubField(entryValue, ',', 28)) as User
;

Can you please explain to me what this error  means and how i can avoid it  ? 

1 Reply
stevejoyce
Specialist II
Specialist II

Looks like just a syntax issue.  if you remove the single quote at the end of Energy2A does this resolve your issue?

IF(entryKey = 'IPL',SubField(entryValue, ',', 20)) as Energy2A',