AnsweredAssumed Answered

I have flatfile with few fields and respective values in rows, i need to transpose the same to target with the all the field names to one column in target and their values to other column

Question asked by gopinath.elangovan199316 on May 28, 2018
Latest reply on Jun 8, 2018 by gopinath.elangovan199316

foreg: 

source: 

 

PGOL3AB
CALISA
GA4010
CALISAGA6020
CALISAGA1111

 

Expected output: 

PGOL3ACCTAMT
CALISA
GAA40
CALISAGAA60
CALISAGAA11
CALISAGAB10
CALISAGAB20
CALISAGAB11

 

Is it possible to transpose the field names and their values like this, its fine we have duplicates. but all the values should be available.

Outcomes