transposed file extraction

Comments (3)

dhaya in New Brunswick, New Jersey

88 months ago

Hi , I have a transposed file which reads like

first name1
ph 1
address1

first name2
ph2
address2

firstname3
ph3
address3

e tc

I want the o/p like
firstname1|ph1|address1
firstname2|ph2|address2
firstname3|p h3|address3

How can I import this file and how can I acheive this o/p in target file ?If it was just the reverse,how can I do that?

Deepak in Cincinnati, Ohio

86 months ago

You can use normalizer

Nandhini in Fords, New Jersey

85 months ago

In the expression transformation create one out port and write the concatnate function which supports ur business logic.

» Sign in or create an account to comment on this topic.