concatenate resident load en nieuwe kolommen toevoegen obv. dynamische field list

PHOTO EMBED

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