IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Concatenaing multiple rows to single row based on a key


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Vignesh Sid

New User


Joined: 04 Sep 2017
Posts: 43
Location: India

PostPosted: Tue Aug 14, 2018 8:59 am
Reply with quote

Hi all,

I have FB file with record length 3000 with records similar to below code:

Code:

----+----1----+----2----+----3----+----4----+----5----+----6
11111111  111  AAAAAAAAAA               SUBJECT1           
11111111  111  AAAAAAAAAA               SUBJECT2           
11111111  111  AAAAAAAAAA               SUBJECT3           
11111111  111  AAAAAAAAAA               SUBJECT4           
11111111  111  AAAAAAAAAA               SUBJECT5           
11111111  111  AAAAAAAAAA               SUBJECT6           
11111111  111  AAAAAAAAAA               SUBJECT7           
11111111  111  AAAAAAAAAA               SUBJECT8           
11111111  111  AAAAAAAAAA               SUBJECT9           
11111111  111  AAAAAAAAAA               SUBJECT10           
11111111  111  AAAAAAAAAA               SUBJECT11           
11111112  112  AAAAAAAAAB               SUBJECT1
11111112  112  AAAAAAAAAB               SUBJECT2


The output file can be VB and should be like:

Code:

----+----1----+----2----+----3----+----4----+----5----+----6
11111111  111  AAAAAAAAAA               SUBJECT1,SUBJECT2,...,SUBJECT11
11111112  112  AAAAAAAAAB               SUBJECT1,SUBJECT2

Could anyone suggest me a way to achieve this.

Thanks,
Viky.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2567
Location: NYC,USA

PostPosted: Tue Aug 14, 2018 10:53 am
Reply with quote

Sure.Search for RESIZE Or SPLICE in DFSORT.
Back to top
View user's profile Send private message
darshansai

New User


Joined: 18 May 2019
Posts: 1
Location: INDIA

PostPosted: Mon Jun 03, 2019 4:02 pm
Reply with quote

could anyone provide solution please
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2448
Location: Hampshire, UK

PostPosted: Mon Jun 03, 2019 4:09 pm
Reply with quote

Please do not revive old topics.

I would guess that the clues provided were enough for TS to come to a satisfactory solution, so it should also do for you. Read the relevant sections of the manual and experiment.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. Is there a way to restrict user login... All Other Mainframe Topics 11
No new posts REMOVE DUPLICATE RECORDS BASED ON A S... DFSORT/ICETOOL 4
No new posts Using sort on VB records based on off... DFSORT/ICETOOL 6
No new posts Need to split single line into two li... DFSORT/ICETOOL 7
No new posts NOT ABLE TO FIND DB2 ROWS DB2 2
Search our Forums:

Back to Top