How can you achieve scan using reformat ?
Answers were Sorted based on User's Feedback
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 |
What does dependency analysis mean in Ab Initio?
What is a partition?
Have you ever encountered an error called “depth not equal”?
How to Create Surrogate Key using Ab Initio?
what does layout means in terms of Ab Initio?
What information is provided by .dbc file extension for connecting to the database?
If I delete 1 partition (in 8 partition multifile) and run the graph. Will the graph run successfully?, If not what error I'm going to get.
Mention what dedup-component and replicate component does?
What is $mpjret? Where it is used in ab-initio?
How can you find the 2nd Highest salary in a file department wise in abinitio?
What is .abinitiorc and What it contain?
Hi friends, i have input like below naresh 10,20 suresh 30,40 i want out put like naresh 10 naresh 20 suresh 30 suresh 40 please help me thank you