Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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
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