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: 
Not applicable

dollar sign expansion within a dollar sign expansion

Hi All

Is it possible to do a dollar sign expansion within a dollar sign expansion?

for example, I have:

set convertdate = Date#(Date($1));

set converttime = Time#(Time($1));

set maketimestamp = timestamp(date#(date($1)) + time#(time($2)));

is it possible to do this?  set maketimestamp = timestamp($(convertdate($1)) + $(converttime($2)));

when I try, it seems to get stuck and the script never finishes loading?

1 Reply
Not applicable
Author

Yes it is possible. Try it with a simple example in your script:

  1. Open Variable Overview (CTRL+ALT+V)
  2. Create variable: vHello = 'Hello ' & $1 & '.'
  3. Create variable: vFood = $(vHello($1)) & ' I like ' & $2 & '.'
  4. Click OK to close Variable Overview
  5. Create a Text box and set text to: =$(vFood('Jack', 'Pizza'))

The text box will display 'Hello Jack. I like Pizza'