How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
Runtime behavior of Normalize and Reformat
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
Difference between output_index and output_indexes in reformat
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
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
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
how to insert/update a csv file by comparing it with another csv file?