Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

user-azadi
New 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

Re: Insert row in csv file from variable

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) ;

1 Reply

Re: Insert row in csv file from variable

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) ;

Community Browser