One file contains header,body,trailer records and header in
a single row as well as trailer too.How to segregate these
header,trailer and body records and once it gets
segregated,i want to make the body data in reverse i.e if i
have 10 body records,the 10th record should be the first
record,9th record should be the second line,etc..
Answers were Sorted based on User's Feedback
Answer / dhirendra
Segregate the header, trailer & body by either using part
by expression component or using filter by exp. Use
next_in_sequence() function to a new column of the data
record. Use sort on descending to sort the data on the
next_in_sequence() column.
Is This Answer Correct ? | 17 Yes | 2 No |
Answer / avijit
Filter the header and trailer records by using FBE or you can use dedupsort.
i/p-->Dedupsort(Keep 1st)-->Dedupsort(Keep last)-->Reformat(out.Rank::next_in_sequence())-->Sort(Rank,Desc)-->o/p
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / mohankumar
Use dedup sort to remove header and trailer records. Next
by using scan component generate seqeunce number, then sort
according to the seqeunce number(Desc).
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rushikesh deshpande
Segregate header,trailer and body by using Reformat with
count 3.and use next_in_seq() to assign number and sort it
in descending order
Is This Answer Correct ? | 2 Yes | 0 No |
How you can delete an object from a tag ? How to use in abinitio graph?
what is the relation between EME , GDE and Co-operating system ?
What is a rollup component? Explain about it.
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
What is the difference between Generate Records Component and Create Data Component?
How scientific data processing is different from commercial data processing?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
How to run a graph infinitely?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
What does dependency analysis mean in Ab Initio?
)what is wrapper script?where it is going to execute and why we go for wrapper?
State the working process of decimal_strip function?