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..
Answer Posted / 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 |
Post New Answer View All Answers
What is MAX CORE of a component?
Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
What is a partition?
What is the function that transfers a string into a decimal?
Where $mpjret is used in ab-initio?
What exactly do you understand with the term data processing and businesses can trust this approach?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
What is the difference between a scan component and a rollup component?
Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?
what is the output when -1 is put in select_expr of FBE?
What parallelisms does Abinitio support?
What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.
Mention what is the syntax for m_dump in abinitio?
What is is a data flow graph?
Give one reason when you need to consider multiple data processing?