Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Data consolidation

Data consolidation 8 years 2 months ago #2224

  • Fran
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 6
  • Thank you received: 0
I am very new to AETL. I have a table that has three fields in it, Code, LineNo, and Address. Here are the sample data:
Code LineNo Address
A 1 Address 1
A 2 Address 2
B 1 Address 1
B 2 Address 2
B 3 Address 3
C 1 Address 1
D 1 Address 1
D 2 Address 2
D 3 Address 3
D 4 Address 4
ETC

I want to consolidate this table so that each record is corresponding to a specific Address. The new table will only have two fields, Code and Address. The data should look like this:
Code Address
A Address 1; Address 2
B Address 1; Address 2; Address 3
C Address 1
D Address 1; Address 2; Address 3; Address 4

Can I do this using AETL?

Thanks,
Frank

Please Log in or Create an account to join the conversation.

Re: Data consolidation 8 years 2 months ago #2225

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7540
  • Karma: 33
  • Thank you received: 412
Everything is possible it is all depends how much you want it

You can do it by using keep value function + calculation
But it is rather complicated example
Or you can use pivot transformation

Watch this online tutorial you will get an idea

www.dbsoftlab.com/online-tutorials/advan...ivot-and-sorter.html

Peter
Mike

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 249 guests and 2 members online