Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

how to load exclude data file to load?

Hi guys,

i have few .csv files with file name filename1_20181025.csv,  filename1_20181026.csv, and filename1_20181026.csv.

now i only want to start the loading from 20182026 onwards. How should i write in loading script??? please help.

Rgds


Jim

1 Reply
rubenmarin

Hi Jim, I think you can read all files from that folder and do a check for each filename, ie:

SET vDateStart = 20181026;

For each filename in filelist('path\*.*')

LET vFileDate = TextBetween('$(filename)', '_', '.')

IF $(vFileDate)>=$(vDateStart) THEN

   // Load file

   LOAD...

ENDIF

NEXT