topic Adding load date & time as new feild in table when appending the data table. in App Development

Adding load date & time as new feild in table when appending the data table.

meenakshi_m — Wed, 06 Jan 2021 05:29:22 GMT

Hello everyone,

Appreciate your response below,

For the entire month there are files uploaded for each day and for month end date there is more than 1 file uploaded and the latest one(uploaded last) with same month end date is considered as final.

In order to differentiate the 2 files with same date field in the table want to add a upload date which will help differentiate the data upload else it will be duplicated.

Re: Adding load date & time as new feild in table when appending the data table.

Anil_Babu_Samineni — Wed, 06 Jan 2021 08:23:07 GMT

There is an function to fetch into field of modified date in qlik (like, FileTime())

Re: Adding load date & time as new feild in table when appending the data table.

meenakshi_m — Wed, 06 Jan 2021 09:07:35 GMT

do you have any script on this like how do I use it can I write this data load editor.

Re: Adding load date & time as new feild in table when appending the data table.

Anil_Babu_Samineni — Wed, 06 Jan 2021 10:23:51 GMT

Did you planned incremental process for this, IF not there won't any complex script required.

Load FileTime() as ModifiedDate From Table..;

On based above line, we can write based on needs.

Re: Adding load date & time as new feild in table when appending the data table.

Ksrinivasan — Thu, 07 Jan 2021 05:42:05 GMT

Hi meenakshi,

script for you:

Script:
SET vpath ='(your file path upto folder name)\Hai*.csv*';

FOR Each File in FileList('$(vpath)')

FileList:

LOAD

'$(File)' as Name,

FileTime( '$(File)' ) as FileTime

autogenerate 1;

Let vCount = NoOfRows('FileList');

Store FileList into (your file path upto folder name)/Hai_$(vCount).CSV] (txt);

have a nice day,

k. srinivasan