topic how to load exclude data file to load? in QlikView

how to load exclude data file to load?

jim_chan — Mon, 29 Oct 2018 08:52:08 GMT

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

rubenmarin — Mon, 29 Oct 2018 09:01:29 GMT

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