Vertical Pivot using Looping transformer.
Posted: Thu Jul 10, 2014 8:32 pm
Hi ,
--- Incoming Source Data
NTFCTN_ID NTFCTN_DT EVENT_TYPE SEQ_NUM NAME VALUE
---------- -------------------- ---------- ---------- --------------- ---------------
311 29-JUN-2014 12:49:38 31 1 EXTRA1 Extra
311 29-JUN-2014 12:49:38 31 2 STATE Florida
311 29-JUN-2014 12:49:38 31 3 CITY Jacksonville
312 30-JUN-2014 12:49:39 31 1 CITY Atlanta
312 30-JUN-2014 12:49:39 31 2 STATE Georgia
312 30-JUN-2014 12:49:39 31 3 CITY Houston
312 30-JUN-2014 12:49:39 31 4 EXTRA1 Extra
312 30-JUN-2014 12:49:39 31 5 STATE Texas
312 30-JUN-2014 12:49:39 31 6 CITY Miami
312 30-JUN-2014 12:49:39 31 7 STATE Florida
313 01-JUL-2014 12:49:40 31 1 STATE California
313 01-JUL-2014 12:49:40 31 2 CITY Los Angeles
313 01-JUL-2014 12:49:40 31 3 CITY Seattle
313 01-JUL-2014 12:49:40 31 4 STATE Washington
14 rows selected.
--- DESIRED FINAL OUTPUT
NTFCTN_ID NTFCTN_DT EVENT_TYPE SET_NUM CITY STATE
---------- -------------------- ---------- ---------- --------------- ---------------
311 29-JUN-2014 12:49:38 31 1 Jacksonville Florida
312 30-JUN-2014 12:49:39 31 1 Atlanta Georgia
312 30-JUN-2014 12:49:39 31 2 Houston Texas
312 30-JUN-2014 12:49:39 31 3 Miami Florida
313 01-JUL-2014 12:49:40 31 1 Los Angeles California
313 01-JUL-2014 12:49:40 31 2 Seattle Washington
I am trying to acheive this using looping transformer but I am lost as this seem to be nested Loop first for Notification_id and then within
that for 2 rows of Name Value combination for 'CITY' and 'STATE'.
Can someone advice me I would appreciate any help.
Thanks In Advance.
--- Incoming Source Data
NTFCTN_ID NTFCTN_DT EVENT_TYPE SEQ_NUM NAME VALUE
---------- -------------------- ---------- ---------- --------------- ---------------
311 29-JUN-2014 12:49:38 31 1 EXTRA1 Extra
311 29-JUN-2014 12:49:38 31 2 STATE Florida
311 29-JUN-2014 12:49:38 31 3 CITY Jacksonville
312 30-JUN-2014 12:49:39 31 1 CITY Atlanta
312 30-JUN-2014 12:49:39 31 2 STATE Georgia
312 30-JUN-2014 12:49:39 31 3 CITY Houston
312 30-JUN-2014 12:49:39 31 4 EXTRA1 Extra
312 30-JUN-2014 12:49:39 31 5 STATE Texas
312 30-JUN-2014 12:49:39 31 6 CITY Miami
312 30-JUN-2014 12:49:39 31 7 STATE Florida
313 01-JUL-2014 12:49:40 31 1 STATE California
313 01-JUL-2014 12:49:40 31 2 CITY Los Angeles
313 01-JUL-2014 12:49:40 31 3 CITY Seattle
313 01-JUL-2014 12:49:40 31 4 STATE Washington
14 rows selected.
--- DESIRED FINAL OUTPUT
NTFCTN_ID NTFCTN_DT EVENT_TYPE SET_NUM CITY STATE
---------- -------------------- ---------- ---------- --------------- ---------------
311 29-JUN-2014 12:49:38 31 1 Jacksonville Florida
312 30-JUN-2014 12:49:39 31 1 Atlanta Georgia
312 30-JUN-2014 12:49:39 31 2 Houston Texas
312 30-JUN-2014 12:49:39 31 3 Miami Florida
313 01-JUL-2014 12:49:40 31 1 Los Angeles California
313 01-JUL-2014 12:49:40 31 2 Seattle Washington
I am trying to acheive this using looping transformer but I am lost as this seem to be nested Loop first for Notification_id and then within
that for 2 rows of Name Value combination for 'CITY' and 'STATE'.
Can someone advice me I would appreciate any help.
Thanks In Advance.