Read files within a given range

PHOTO

Mon May 23 2022 00:17:34 GMT+0000 (Coordinated Universal Time)

Saved by @jmbenedetto #qlik

FOR period = 10001 TO 10101
                IF NOT ISNULL(QVDCREATETIME('lib://PATH\FILE$(period).qvd')) THEN

Table:
LOAD
*,
FROM [lib://PATH\FILE$(period).qvd]
(qvd);
END IF
NEXT;
;

https://community.qlik.com/t5/Connectivity-Data-Prep/Multiple-file-load-with-file-name-range/td-p/136455

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

Qlik Sense

@jmbenedetto

Load a limited number of lines from file into Qlik Script Read files within a given range Create inline table Iterate over a table in QS Transform csv file into QVD Copy/rename files Scramble the values of a column by replacing them with other values from the same domain Create a table using values on a variable Create a table with all files respecting the name pattern Developer mode in Qlik Sense SaaS Define URL to call Qlik Automation Sort values on a list

Calculating field percentage in Qlik

sum(myNumber)/sum(total{1} myNumber)

Load a limited number of lines from file into Qlik Script

[memory_table_name]:
First 100 Load
     *
From [data_file.qvd](qvd);

Read files within a given range

FOR period = 10001 TO 10101
                IF NOT ISNULL(QVDCREATETIME('lib://PATH\FILE$(period).qvd')) THEN

Table:
LOAD
*,
FROM [lib://PATH\FILE$(period).qvd]
(qvd);
END IF
NEXT;
;

Define URL to call Qlik Automation

LET vAutomationURL='$(vBaseAutoURL)$(vAutomationID)/actions/execute?X-Execution-Token=$(vAutomationToken)&application=&'& DocumentName()

Sort values on a list

Match(FieldName, 'Value1','Value11', 'Value111', 'Value1111')

Browse more snippets >>