Create a table with all files respecting the name pattern

PHOTO

Sun Oct 16 2022 22:01:04 GMT+0000 (Coordinated Universal Time)

SET vSourcePath = 'lib://01 - HR Demos (LoB) (Development):DataFiles/';
SET vPrefix='A0090_';

for each File in filelist ('$(vSourcePath)'&'$(vPrefix)'&'*.qvd')
[FileList]:
  LOAD
  	mid('$(File)',len('$(vSourcePath)')+1) as FileName
  autogenerate 1;
next File

COPY

Save snippets that work from anywhere online with our extensions

Comments

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

#qlikcloud

Create a table using values on a variable

LOAD
	SUBFIELD('$(vTablesList)',',') as table_name
	Autogenerate 1;

#qlikcloud

Create a table with all files respecting the name pattern

SET vSourcePath = 'lib://01 - HR Demos (LoB) (Development):DataFiles/';
SET vPrefix='A0090_';

for each File in filelist ('$(vSourcePath)'&'$(vPrefix)'&'*.qvd')
[FileList]:
  LOAD
  	mid('$(File)',len('$(vSourcePath)')+1) as FileName
  autogenerate 1;
next File

Create a table with all files respecting the name pattern

Save snippets that work from anywhere online with our extensions

Comments

More like this

Qlik Sense

Browse more snippets >>

Create a table with all files respecting the name pattern

Save snippets that work from anywhere online with our extensions

Comments

More like this

Qlik Sense

Browse more snippets >>

Embed code snippet