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 |
If m loading a file of 1 million records.and the graph fails after loading 10,000 records. In this case if we use rollback command then what will happen?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?
How can you find the 2nd Highest salary in a file department wise in abinitio?
We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?
How can you import XML repositories exported from different tools like ODI
What is the difference between rollup and scan?
Mention what is a partition and what are the different types of partition components in abinitio?
Which Ab initio version has Hadoop connector ? and what is the latest GDE version available ?
Difference between output_index and output_indexes in reformat
How can you increase the number of ports of your output flow? What is the limit? Can i have 20 out ports?
How can you view the data in the Multifile
How scientific data processing is different from commercial data processing?