Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
In the data load window I may see tables that are loading in my app and how much rows they are contained.
I need to create an additional part of the script in the app that may save date and time whan each table start and end loading.
It should be table like
Tablename|Start load |EndLoad
Table 1 |2019/11/02 10:09:35|2019/11/02 10:13:30
How I may do it?
Hey,
LET v_ReloadStart = Now();
LET v_TableName= 'Temp';
$(v_TableName):
LOAD *
Inline [
vProfileB12,ArrayValues
A,1;2;3;4;5;6;7;8;9;10;11;12;13;14;15];
LET v_ReloadEnd = Now();
Meta:
Load
'$(v_TableName)' as TableName,
'$(v_ReloadStart)' as ReloadStart,
'$(v_ReloadEnd)' as ReloadEnd
AutoGenerate 1
;
STORE Meta into lib://Desktop/\Meta.qvd (qvd);
Hey,
LET v_ReloadStart = Now();
LET v_TableName= 'Temp';
$(v_TableName):
LOAD *
Inline [
vProfileB12,ArrayValues
A,1;2;3;4;5;6;7;8;9;10;11;12;13;14;15];
LET v_ReloadEnd = Now();
Meta:
Load
'$(v_TableName)' as TableName,
'$(v_ReloadStart)' as ReloadStart,
'$(v_ReloadEnd)' as ReloadEnd
AutoGenerate 1
;
STORE Meta into lib://Desktop/\Meta.qvd (qvd);
Brilliant!
Thank you!