This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Hello all, is there a way to auotmatically change the name of the file in the store function or a way where the store function will create multiple files instead of replacing the old file upon upload?
load [csId] as 1 ,[eCd] as 2 ,[te] as 3 Resident Test;; STORE export into (txt, delimiter is ','); drop Table export
STORE export into Q:\Monthly Reports\export_$(vName).txt (txt);
You can see this:
Store Qvd file with Timestamp value
Or you can use incremental
FOR Each Ext in 'txt'
FOR Each File in FileList ('$(vPath)'&'\*.'&Ext)
'$(File)' as Name,
FileSize( '$(File)' ) as Size,
'.xlsx','') as ShortName,
FileTime( '$(File)' ) as FileTime
max(PurgeChar(ShortName,'export_.txt')) as num
Where left(ShortName,7) = 'export_';
drop tables Files, t1;
(biff, embedded labels, table is Facts$);
STORE t1 into C:\1\export_$(vName).txt (txt);
define a variable and use it to create new name to your file
or simple append your file name with some timestamp
STORE export into '';
[export] into Q:\Monthly Reports\export_$(vDate).txt (txt, delimiter is ',');
STORE [export] into Q:\d771\F88776\SHARED\CompanyRead\Network Informatics\Special Projects\John Mingus\Qlikview\Monthly Reports\export_$(vDate).txt(TXT);
Not recogonizing the variable and I get an error to reload old data after the refresh. See anything incorrect with the syntax above? When I remove the variable in the STORE statment the scrip runs...
Check out the attached application it has the similar code and it does work.
Please check if your access are proper to the folder where your application is trying to store the file
My script runs when I remove the variable piece from the store command. It's only when I add the variable that the script bombs out "Execution of script failed. Reload old data"
can you put a sample qvw replace your load statement with simple inline and keep table name and store statement variable etc same