Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using subfield to split several strings. To have a better overview of the process I splited the script in several preceding loads and was wondering why I get different result compared to a "resident load". Does anyone has a explanation for the following behaviour:
Result Preceding Script:
Result with Resident Load:
Why do I not get the same results?
Or is the answer just: WAD?
Thanks for any help.
/Andi
This may well be a bug. The first example returns an incorrect result. We (Qlik) will investigate.
However, you can use multiple SubField:s in the same load. The following returns a correct result:
Load
SubField(FieldB,'|') as FieldB1,
SubField(FieldA,'|') as FieldA1,
*
Inline
[FieldA, FieldB
Value1|Value2, 3100|3101|3105|3110
Value1|Value2, 3100|3101|3105|3110 ];