Need to transform into (merge multiple line into ONE record.. number of
lines has to be merged is always constant 7 , first line { and 7th line -}
{11111111111111113333333:44444444:55:66-}
{ ...................-}
Read the data from the file as a single column. Use stage variables to queue data and output on change of group --> the "}" character. Since your last row should be that } character you shouldn't have the issue of the last group not being output.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
As Ken said you can do that or you can use the mod function(mod(@INROWNUM,7) to split the records.
Another way to do is create 7 different hash file and merge is one job. While creating the hash file you need to generate the key either by using the stage variable or use the mod function. This is just an another way of doing. But the first mentioned one is the most efficient way of doing.