Answer Posted / ruknamw@yahoo.com
To create a simple sequence, the next_in_sequence() function can be used in a reformat.
In order to get cumulative summary, temporary variables can be used iteratively to increment a particular column by adding the previous value with the current value incrementally.
If a Key is involved, we need to ensure that the Key is sorted before the Reformat. A key change function using variables need to be written such that if the Key's current value is not equal to the previous value, the group has changed and the cumulative total needs to begin again with the current record value. If multiple columns make a key, the values can be concatenated for the key change verification.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a look-up?
What dedup-component and replicate component does?
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
Explain the methods to improve performance of a graph?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
How to compare two dmls in abinitio
Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low
Give one reason when you need to consider multiple data processing?
How can you export a component’s internal parameters ?
How does the bre work with the co>operating system?
can we perform checkin and checkout through sandbox?
How to run a graph infinitely?
What kind of layouts does abinitio support?
Describe in detail about lookup?
What is local and formal parameter?
