Variables

More
4 years 2 months ago #21766 by bruce.gibbins
Variables was created by bruce.gibbins
AETLE(P) v6.3.9.4 (x32/x64)

HI

I was wondering if you would consider adding some extra System Variables? In particular one to identify the Package Group Name.

As per www.etl-tools.com/wiki/advanced-etl-proc.../packages/variables/ we and which we use in various IT emails to help identify the ETL Package that ran. But to give a bit more transparency to where the Package lives it would be helpful to have as well of possible.

Also, I was wondering if you had ever considered having a Variable Type that was actually a LIST rather than just a string. I realise I could use a delimited string for what I want to do but that then leads to scripting.

For example, we may get a batch a batch of files from a partner. Some of which we need to transform, but we need o store all of them. I wanted to have a memory variable that say held a list of 'codes' that are embedded in the inbound filename. Then during the package run I may want to check that list with a single action (rather than write some script to parse a delimited string) to see if a specific filename (aka code) came in and if it did then do something else.

This is a rather cobbled together scenario and not necessarily real. But I hope you get the idea.

Thanks for your consideration

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