Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Is it possible to load inline data containing a newline character?
I want to do something like this however Qlik interprets the newline in my string as the end of the record - and so truncates the string after 'Rule 1'. (Some strings may be quite long hence the requirement to separate across lines.)
let businessRule = 'Rule 1
OR rule 2
OR rule 3
etc';
ValidationRules:
load * inline [
BusinessRule
$(businessRule)
];
Any help much appreciated!
Gary
Yes you can if you use msq quoting like this:
let businessRule = 'Rule 1
OR rule 2
OR rule 3
etc';
DATA:
LOAD * INLINE [
ID,TXT
1,"ABC
DEF
GHI"
2,LMN OPQ
3,"$(businessRule)"
] (txt, msq );
The DATA table will contain 3 rows. The TXT field of the first row will have three lines and the TXT field of the third row will have four lines.