topic Script - Subfield and preceding Load in App Development

Script - Subfield and preceding Load

andrpfist — Tue, 12 Apr 2022 06:24:28 GMT

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

Re: Script - Subfield and preceding Load

hic — Tue, 12 Apr 2022 08:05:23 GMT

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 ];