Req - External Application - Replace Variable

More
9 months 3 weeks ago #25745 by prashant
Currently ,

1. in parameters If I wish to include a variable , I need to first keep it static, then enter my string , then come back and change it to variable 
2. while it's variable , if I click the ... button it opens the variable window

 

I propose having SQL to variable type , REPLACE VARIABLE option , 
 
 
The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

More
9 months 3 weeks ago - 9 months 3 weeks ago #25752 by Peter.Jonson
There s a better option if you double click in the middle of the edit box you will see another editor

The menu has no "Insert variable" option but we will add it to the next release


Peter Jonson
ETL Developer
Last edit: 9 months 3 weeks ago by Peter.Jonson.

Please Log in or Create an account to join the conversation.

More
9 months 2 weeks ago #25761 by prashant
It would be great if we can also have variables which have been defined from the same package

SET VARIABLES list also 

and an absolute mega monster cherry on top would be if script defined variables can be picked up like etltools.SetVariable('#s3_url#', final_s3_url)

 
The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

More
9 months 2 weeks ago #25764 by Peter.Jonson
If you run the package once you will see all the variables. 

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
9 months 2 weeks ago #25784 by Peter.Jonson
The following user(s) said Thank You: prashant

Please Log in or Create an account to join the conversation.

More
9 months 2 weeks ago #25790 by prashant
Thank you ! I also learned the trick of double clicking to take me straight to note editor, for some reason I always kept clicking the ... button 
The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save