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 is extension list in abinitio?
How transaction file different from that of a sort file?
What is the latest version that is available in Ab-initio?
How does the bre work with the co>operating system?
What is the role of co-operating system in abinitio?
Which Ab initio version has Hadoop connector ? and what is the latest GDE version available ?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
How to move data from developement to testing and testing to production?
1 Answers BitWise, CTS, Satyam, Wipro,
Name the different type of processing based on the steps that you know about?
What is the significance of record required indicator of Join component ? How to use in abinitio graph?
How to get DML using Utilities in UNIX?
What is dependent parameter ?