Input -
Name|city |startyear
Rahul |Mumbai|2010
Rahul|kolkata|2014
Rahul|Delhi|2018
Output should be-
Name|city |startyear|endyear
Rahul |Mumbai|2010|2014
Rahul|kolkata|2014|2018
Rahul|Delhi|2018|9999
Answer / yash
We can use rollup to convert whole data in vector and later use vector data in normalize to assign last column.
rollup: use accumulation function on all columns
NORMALIZE:
length :: 3;
out::normalize(in,index)=
begin
out.name :: in.name[index];
out.city :: in.city[index];
out.startyear :: in.startyear[index];
out.endyear :: if(index==2) 9999 else in.startyear[index+1];
end;
| Is This Answer Correct ? | 0 Yes | 0 No |
How to connect mainframe to Abinitio?
Difference between private project parameters ,public project parameters and common project parameters?
What is data encoding?
what is different daily and monthly develop the abinitio graphs?
Explain how abinitio eme is segregated?
What is dependent parameter ?
Can any body give me the clear explanation about how to separate header,trailer and body records in Ab Initio?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
What are “business rules” in ab initio business rules environment (bre)?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
What is the difference between Generate Records Component and Create Data Component?
I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?