cancel
Showing results for 
Search instead for 
Did you mean: 

How to use lookup function

former_member498903
Participant
0 Kudos

Hi,

I am using Data Services XI 3.2, i wanted to perform LOOKUP on City database of USA country against the data that i have in my Excel spread sheet.

I have followed the following procedure.

1. In my job, i have taken 2 source table, 1 as CITY database of USA and 2 City and other information containing spreadsheet.

2. used join transform, created the new output column called 'CITY', used the LOOKUP_EXT function in Mapping Tab and performed the following query.

lookup_ext(Database_name.DBO.city_zip_lookup_table,'PRE_LOAD_CACHE','MAX],[CITY],[NULL],[CITY, '=', excel_spreadsheet.city]')

By using this standard function I am not getting the expected output.

I want my output to be..

In the newly created CITY table, the output should be coming from the 'CITY_ZIP_LOOKUP_TABLE'.

It should validate the city value from excel spreadsheet with the CITY_ZIP_LOOKUP_TABLE and populate the value from lookup table.

Regards,

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

I did not see any problem with the lookup. Whats your expected output? Do you have any other key that matches with the table?

Arun

former_member498903
Participant
0 Kudos

Hi,

I don't have any other key in city_zip_lookup table that matches with the Excel_spreadsheet except CITY field.

In my lookup table it contains only CITY and zip Related data, which matches only with the CITY_table field in Excel spreadsheet.

Regards,

Former Member
0 Kudos

Can you give me a snapshot of the output and whats wrong with it?

Arun

Former Member
0 Kudos

can u explain wat error u r getting?