Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Knowledge
Qlik Sense - ODAG Unable to pass filtered value with comma
Article Number: 000065606 | Last Modified: 2019/02/27Description
If you try to generate an application using ODAG with a value containing a comma, the application will be generated without data.
Environment:
Qlik Sense February 2019 (Potentially earlier version are also affected)
Environment:
Qlik Sense February 2019 (Potentially earlier version are also affected)
Cause
The inline binding option never attempts to quote any of the field values it writes to an INLINE table.
Resolution
A solution is to use a different delimiter in the inline table, for example | (pipe) instead of the default , (comma).
This requires that we are sure that any values in Dim1_ field does not contain the | (pipe) character.
OdagBinding:
LOAD * INLINE [
VAL
$(odso_Dim1_){"quote": "", "delimiter": ""}
]
(ansi, txt, delimiter is '|', embedded labels);
The first SET statement should be empty string.
SET Dim1_ = '';
This should be done for all fields."
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us