concatenate resident load en nieuwe kolommen toevoegen obv. dynamische field list
Wed Aug 07 2024 10:05:12 GMT+0000 (Coordinated Universal Time)
Saved by
@bogeyboogaard
LET vFieldCount = NoOfFields('LINK');
FOR i = 1 TO $(vFieldCount)
LET vFieldName$(i) = FieldName($(i), 'LINK');
NEXT i;
// Step 2: Construct dynamic load script
SET vLoadScript = '';
set vSkipFields = 'el1#,el2#,el3#';
FOR i = 1 TO $(vFieldCount)
trace TRACE field $(vFieldName$(i));
IF WildMatch(vSkipFields, '*$(vFieldName$(i))*') THEN
// If both match, log the result and continue
TRACE Matched: $(vFieldName$(i)) and skipped;
else
LET vLoadScript = '$(vLoadScript)' & '$(vFieldName$(i)),';
ENDIF;
NEXT i;
LET vLoadScript = LEFT('$(vLoadScript)', LEN('$(vLoadScript)') - 1); // Remove the trailing comma
exit script;
content_copyCOPY
https://htm-rapportage.eu.qlikcloud.com/dataloadeditor/app/7cead63c-b08c-4c31-831d-fb32b17f8310
Comments