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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to archive a file which is 90 days older than the run date passed during job run

Hi,

I will pass run date (format: yyyymmdd) during job run and i have to archive the files from a folder which are 90 days old from the run date which i have passed.

 

The files in the folder are of the format

 

abcdefgh.Dyyyymmdd. 

How can this be achieved

Labels (2)
25 Replies
Anonymous
Not applicable
Author

Hi,

 

I did a test run of all components (by passing input to fixedflowinput and running the refdate value in a tmap and writing to tLogRow) except the tfilelist to check where i have gone wrong.

 

But for tfilelist i dont know how to test it out individually.

 

Sorry for this and thanks for your time

TRF
Champion II
Champion II

You need to create files by yourself for input and connect a tJava to tFileList to print global variables associated to this component.
Could be time to mark your case as solved...
Anonymous
Not applicable
Author

Hi,

 

As mentioned earlier files are already there in the folder which are more than 90 days old than the run date passed as a context variable.I connected tfilelist to tjava to see the output from the former and found that when i have context.filename+"*.gz" in my filemask in tfilelist component i got the output as /data/Archive/ (sourcepath)
20190712 (as the date that is 90 days less than context run date).

But my tsetglobalvar_2 still throws null pointer exception.  0683p000009MPcz.png.

I couldnt figure it out.

Also this is giving me only 1 particular file date whereas my requirement is to archive all the files which are greater than 90 days .

 

Any help

 

TRF
Champion II
Champion II

Export your job (export element) with dependencies and send it to me
Anonymous
Not applicable
Author

attaching the exported job

TRF
Champion II
Champion II

something is missing...