Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
sifatnabil
Specialist
Specialist

Load reloadtime() or now() as a field in script

Hi,

How can I use the value of reloadtime() and use it as a field within a table inside the load script?

I tried using let reloadtime = reloadtime() and then in the table:

test:

load reloadtime as loadtime;

Anyone know how? I need to know reloadtime() or now() and store it inside a QVD.

1 Solution

Accepted Solutions
MayilVahanan

Hi

Try like this

Let  ReloadTimeReloadTime();
LOAD '$(ReloadTime)' as ReloadTime AutoGenerate 1;

But its show the last reload time only. Not reload time.

i.e. This ReloadTime field value varies when u see the function value of ReloadTime() in textbox.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies
MayilVahanan

Hi

Try like this

Let  ReloadTimeReloadTime();
LOAD '$(ReloadTime)' as ReloadTime AutoGenerate 1;

But its show the last reload time only. Not reload time.

i.e. This ReloadTime field value varies when u see the function value of ReloadTime() in textbox.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
sifatnabil
Specialist
Specialist
Author

Thanks, I used now() instead and it worked!

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Let  ReloadTimeReloadTime();
LOAD

'$(ReloadTime)' as ReloadTime

AutoGenerate 1;


LOAD

Now() as NowTime

AutoGenerate 1;


Regards,

Jagan.