Close





Lost Password?
No account yet? Register
Increase font size Default font size Decrease font size Narrow screen resolution Wide screen resolution Auto adjust screen size default color red color blue color yellow color orange color
Support Forum
Welcome, Guest
Please Login or Register.    Lost Password?
Support Forum Forum The Suggestion Box
Re:AETL Lookup Object (1 viewing) (1) Guests
Go to bottom Post Reply Favoured: 0
TOPIC: Re:AETL Lookup Object
#558
MariaC (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
AETL Lookup Object 1 Year, 6 Months ago Karma: 0  
Hello.

Just a quick one.
I am working with lookup _object_ a lot and the list of values changes quite often.

It would be great to be able to pull the list from the data_base_ of file automatically before transforming the data.

It will save me a lot of time

Best Regards,
Maria
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#559
admin (Admin)
Admin
Posts: 147
graph
User Online Now Click here to see the profile of this user
Re:AETL Lookup Object 1 Year, 6 Months ago Karma: 0  
Thank you for your suggestion.

It is already on our endless development plan and will be available in next release

Peter
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#679
dadress (User)
Fresh Boarder
Posts: 12
graphgraph
User Offline Click here to see the profile of this user
Re:AETL Lookup Object 8 Months, 2 Weeks ago Karma: 0  
If I use a lookup _object_. How do I use the incoming field to lookup against? In my sql do I specify something like Where Field = :in.field
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#682
admin (Admin)
Admin
Posts: 147
graph
User Online Now Click here to see the profile of this user
Re:AETL Lookup Object 8 Months, 2 Weeks ago Karma: 0  
It depends on what you are trying to achieve

If you want to validate your data against list of values use Validator + InList _object_
If you want to transform data eg: Replace M with Male and F with female etc, use Transformer + Lookup _object_

Peter
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoard
 

Testimonials

I just transferred 10,000,000 million records from the main SQL Anywhere database over the network into a Postgres database without a hitch.

Thank you
Thank you
Thank you

George…

!!!!! You guys rock!!!!!!!!
 

Free Newsletter

Please provide your Name and Email address so that we can tell you about latest releases, new features and free offers.






b.150.100.16777215.0..Screenshots.DEWizardX.properties.JPG
DB Software Laboratory - Intel Software PartnerDB Software Laboratory - My SQL Ready Partner
DB Software Laboratory Embacadero Technology Partner