ETL and Data Integration tools - Modern ETL software for everyone

* Version Number = Advanced ETL Processor Ent. 4.2.3.5

* Repository type = MS Excel 2007

* Database type you are working with. = .XLS

* OS = Windows 7

I am trying to import legacy data from one data source into into an excel and as part of the transformation of the data before reloading I have to look up legacy chart of account numbers and cross reference from a list to New chart of account numbers from a 2 column excel SS.

for example
if the legacy data line contains account number 1000 I am required to output to the new spreadsheet 10100
if the legacy number is 1005 I will output 10200 and so on.

Can I use a look up table to accomplish this or go through the tedious task of setting up a "Replace Characters" scenario for all the instances (of which I have about 1000 legacy accounts)

Legacy# New#
10000
1000 10100
1005 10200
1010 10250
1050 10300
10400
10810
1920 10820
11000
1100 11020
1110 11020
1112 11020
1115 11020
1120 11020
1125 11020
1127 11020

Thank You!

Yes this is what lookup object for

have a look at this tutorial
www.dbsoftlab.com/online-tutorials/advan...g-lookup-object.html

It will give you some ideas

Mike

Yes Mike, I had reviewed that tutorial but was not clear on the output mapping, User Manual was vague for me also but through trial & error yesterday I figured it out (along with 5 ways NOT to set it up) lol
Thanks for your continued support!
Dave

Updating documentation and tutorials is on our massive list of things to do
I am glad you are making progress

Mike