Need help for a simple task

[Former Member]

I have a customers (actually companies) TABLE which has one customer order per row and also the customer details in columns like ID, Address, Name (unique names) etc. BUT, there is no phone number column. The phone numbers are stored in a csv file, along with the corresponding ID.

I want to make a csv file which will have select columns from customers TABLE and also a new column for phone numbers. Please suggest some ways to do this.

Is it advisable to lookup the csv file to put the right phone numbers for a customer ? If yes, how to do it ?

[former_member200473]

Hi Sappy,

kindly try by outer join also.

Regards,

Shiva Sahu

[former_member202087]

You can't really use a lookup or lookup_ext function with a flat file.  Depending on the size of your file it is probably just best to pull the flat file into data services and do a left outer join in a query transform between the table and the flat file. 

[Former Member]

Hello

Actually, you can use a file as a source in the lookup functions.

Michael

[former_member202087]

My bad.  Thanks Michael.  I stand corrected.  Need to look a little closer at those drop downs.