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?
Re:How do I use a lookup (1 viewing) (1) Guests
Go to bottom Post Reply Favoured: 0
TOPIC: Re:How do I use a lookup
#680
dadress (User)
Fresh Boarder
Posts: 12
graphgraph
User Offline Click here to see the profile of this user
How do I use a lookup 8 Months, 1 Week ago Karma: 0  
I am new to this and I am trying to figure out how to use a lookup component. In my reader I have a field called Fac

In my lookup table I have a field called facilityID, facility - I want to lookup facility and get the iD number to insert into my destination table. How do I do it?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#681
admin (Admin)
Admin
Posts: 147
graph
User Online Now Click here to see the profile of this user
Re:How do I use a lookup 8 Months, 1 Week ago Karma: 0  
David

Add an lookup _object_ to your transformation an _link_ it to source and target
Double click on lookup _object_ to change it properties
select lookup source data
and set all necessary connection details
First field in lookup source is always key and second is a value

for example

if you have a field with two possible values 1 and 0 and you would like to convert it to Yes and No

You lookup table or file will look like

Key Value
1 Yes
0 No

We can create a video for you if you wish

John

PS

I think would be beneficial for you to know that we are currently adding support for direct connection for MySql,Inter_base_ and PostgreSql data_base_s
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoard

Testimonials

We had two thousands text files in same format. We were able to load them in one click using Visual Importer ETL .

Pol Barret,
Accountant

 

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.AdvancedETLEnt.Advanced_ETL_Processor_Ent_Groupper.jpg
DB Software Laboratory - Intel Software PartnerDB Software Laboratory - My SQL Ready Partner
DB Software Laboratory Embacadero Technology Partner