Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Afternoon,
how I could create a QVD with the filename + year + month reload?
Example: NomeArquivo2013jul.qvd
Att,
JH
Hi,
This should work:
Let vFileName = Year(ReloadTime()) & Month(ReloadTime());
[TABLE]:
LOAD * INLINE [
teste, codigo
1, 3
2, 4];
STORE [TABLE] INTO [ C:\Users\Avacon\Desktop\$(vFileName).qvd];
Regards,
Sokkorn
Hi ty this
left(NomeArquivo2013jul,11) AS Filename,
mid(NomeArquivo2013ju,11,4) AS Year,
Right(NomeArquivo2013ju,3) AS Month
Thanks
Sorry,
but I did not, I need to put the name in arquivo.qvd
example
STORE [TABLE] INTO [$ (vdir) \ QlikView Year Month. QVD];
Year and month would be according to the month and year of the reload!
You need to do something like that:
STORE INTO 'NomeArquivo' & Year(ReloadTime()) & Month(ReloadTime()) & '.qvd';
Sorry,
but there's no way to work, I had passed this command, but he writes everything I step STORE:
example:
'FileName' & Year (ReloadTime () & Month (ReloadTime ()). QVD
what am I doing wrong?
[TABLE]:
LOAD * INLINE [
teste, codigo
1, 3
2, 4
];
STORE [TABLE] INTO [ C:\Users\Avacon\Desktop\'NomeArquivo' & Year(ReloadTime()) & Month(ReloadTime()) & '.qvd'];
Use:
LET NomeArquivo = 'C:\Users\Avacon\Desktop\NomeArquivo' & Year(ReloadTime()) & Month(ReloadTime()) & '.qvd';
STORE
Hi,
This should work:
Let vFileName = Year(ReloadTime()) & Month(ReloadTime());
[TABLE]:
LOAD * INLINE [
teste, codigo
1, 3
2, 4];
STORE [TABLE] INTO [ C:\Users\Avacon\Desktop\$(vFileName).qvd];
Regards,
Sokkorn
Hi
Check the attached qlikview file
Regards
Harsha
thanks for the help!