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
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?