topic Re: Only load files filetime() > Date in QlikView

Only load files filetime() > Date

Keyuser — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys!

Load many xls files from a folder
(load *, from Folder / *. xls)

But now I have the problem that from a certain date new fields have been added which I would now like to load.

concatenate
load Distinct
newfield
FROM Folder / *. Xls

How can I load only files larger spezific daten?

concatenate
load Distinct
newfield
FROM Folder / *. Xlsm where filetime() > '01.10.2019'

does not work. QlikView still tries to check all files and of course does not find the new field in the old files.

Thanks.

Re: Only load files filetime() > Date

Anonymous — Wed, 23 Oct 2019 13:42:42 GMT

you need a field containing a date format which identifies the new records
you may
concatenate
load Distinct
newfield
FROM Folder / *. Xlsm where datefield > '01.10.2019'

other way if you have an unique identifier /keyfield

concatenate load Distinct
newfield
FROM Folder / *. Xlsm where not exist (unique_identifier)

Re: Only load files filetime() > Date

Brett_Bleess — Thu, 31 Oct 2019 18:42:53 GMT

Michael, did the post help you get something working as needed, or are you still working on things? If the prior, do not forget to come back to the thread and use the Accept as Solution button to mark the post that helped you get things working. If you did something different, consider posting that and then mark it, and if you still require help, please leave an update for us.

The following Design Blog post may give you another avenue as well:

https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543

Regards,
Brett

Re: Only load files filetime() > Date

Surya — Fri, 01 Nov 2019 05:35:46 GMT

Hello., LOAD PGMI_KEY_INV, VALUATED_STOCK_INV, DATE( MAKEDATE (RIGHT(RIGHT(FileBaseName(),10),4), MID(RIGHT(FileBaseName(),10),4,2), LEFT(RIGHT(FileBaseName(),10),2)) ,'DD-MM-YYYY') as VALUATED_DATE FROM [C:\Qlikview Primary\JSPL\Module Wise Base Data Modeling\MM\QVD\Daily Store\VALUATED_INVENTORY_GWI_*.QVD] (qvd) where DATE( MAKEDATE (RIGHT(RIGHT(FileBaseName(),10),4), MID(RIGHT(FileBaseName(),10),4,2),LEFT(RIGHT(FileBaseName(),10),2)),'DD-MM-YYYY') = date(Today(),'DD-MM-YYYYY'); ; May Be help full to u this

Re: Only load files filetime() > Date

Arthur_Fong — Fri, 01 Nov 2019 06:39:42 GMT

Try this:

FROM Folder / *. Xlsm where filetime() > date#('01.10.2019','DD.MM.YYYY')

FROM Folder / *. Xlsm where filetime() > '01.10.2019'

This doesn't work since '01.10.2019' is a string, it couldn't be evaluated.

Eg:

filetime()>'abc'. It doesn't work that way.

Using date#('01.10.2019','DD.MM.YYYY') will evaluate '01.10.2019' as a date format.

Then, you may use where clause to evaluate filetime() accordingly.

Thanks and regards,

Arthur Fong