Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
user-azadi
Contributor III
Contributor III

Insert row in csv file from variable

hi everyone

i want to update qvd file and for that i need to know last time of update it.

i create csv file and need to append time of update in every load app.

i know we must use variable , but i don't know  continue it.

please help me with example, thanks

1 Solution

Accepted Solutions
Anonymous
Not applicable

Personally I'd create a qvd file and in the load script add a row to it something like this :

QVD_Updated :

Load

now()  as [QVD Updated]

autogenerate 1

;

if ( FileSize ( 'lib://Folder/QVD_Updated.qvd' ) > 0 ) then

trace File Exists ;

Concatenate ( QVD_Updated )

    Load * from [lib://Folder/QVD_Updated.qvd] (qvd) ;

end if ;

Store QVD_Updated into [lib://Folder/QVD_Updated.qvd] (qvd) ;

View solution in original post

1 Reply
Anonymous
Not applicable

Personally I'd create a qvd file and in the load script add a row to it something like this :

QVD_Updated :

Load

now()  as [QVD Updated]

autogenerate 1

;

if ( FileSize ( 'lib://Folder/QVD_Updated.qvd' ) > 0 ) then

trace File Exists ;

Concatenate ( QVD_Updated )

    Load * from [lib://Folder/QVD_Updated.qvd] (qvd) ;

end if ;

Store QVD_Updated into [lib://Folder/QVD_Updated.qvd] (qvd) ;