Hi, I am trying to figure out how to solve this particular requirement:
I will get a flat file as an input file. This input file will contain user information of some sort, separated by Pipes. For each user, we may have at max 10 rows in a file.
In the output file, we need to summarize all the information separated by pipes in a single row.
As you can see, one user can have more than one, but at max 10 access Levels. we need to summarize them against each user name,and some basic user information given in the input file.
Any Guesses ? I am trying to see if I can use JoinKeys or Splice for this,
however, will appreciate if I can get a helping hand real quick.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
What is the key here? Is it the first field (e.g. Sachin) or the first three fields (Sachin|USE|MF) or something else?
What is the maximum length of each field?
What is the RECFM and LRECL of the input file?
The way you show the output records indicates that you want them to contain 12 pipe signs (|) even if there aren't 10 records for a key. Is that really what you want?
Hi Frank and Kolusu, Thanks for responding.
Apologies for the delay on from myside in answering to Frank's questions.
The key was 'Sachin|USA|MF|', Record format is Fixed Block, while input Record length will be around 1000. Also, irrespective of whether the user has all 10 access levels or not, we have to show 10 pipe delimited columns (i really don't understand this part, but that's the requirement).
Thanks for helping me with this code. I will try out, and i am sure this will work.
As always, can't thank you enough for the great help.