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
No Answer is Posted For this Question
Be the First to Post Answer
How will you check the latest versions in EME?
I wanted to learn Ab Initio, Could you please send the material to my personal email id.
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?
What is use of creating a save files? How to use in abinitio graph?
1 Answers Cognizant, IBM, Intellego, TCL,
What would be the next step after collecting the data?
What is the difference between a scan component and a rollup component?
Explain what does dependency analysis mean in abinitio?
How can you import XML repositories exported from different tools like ODI
Do we really work with ACTUALDATA in development phase.
Can anyone give me an example of realtime start script in the graph?
What are the different versions and releases of ABinitio ?
Explain how you can run a graph infinitely in ab initio?