Home > IT Answers > Database > Comparing 2 files .CSV and getting the missing data using AS400.
0 pts.
 Comparing 2 files .CSV and getting the missing data using AS400.
DB2 Universal Database, RPG, RPGLE
I have 2 files of .CSV format. I need to compare them and capture the missing data into Excel sheet. How do i do this using AS400???

Software/Hardware used:
ASKED: February 27, 2007  6:46 AM
UPDATED: January 3, 2010  10:18 AM
RELATED QUESTIONS
Answer Wiki:
if you're comparing CSV files, and exporting to excel, why bother with the AS400? I'd use Access, it can open a CSV file, and I think it can save query results as excel. I'm pretty sure there's a construct to find records that are missing from either file, but, I can't think of it off the top of my head. worst case, you can union two not in statements to get the same results.
Last Wiki Answer Submitted:  February 27, 2007  8:28 am  by  MODMOD   0 pts.
All Answer Wiki Contributors:  MODMOD   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Do you want to compare the .CSV files or the data in the files? For example, a numeric column might be 003.010 or it might be 3.01 — leading and trailing zeros make the file different even though the values are different. If you’re going to report differences back in Excel format, I’d expect that you’d want to compare the data while ignoring file differences.

Therefore, you might want to import the .CSV files into a database format. Then compare the resulting files. Differences should be reported in a XML format since Excel handles XML easily enough and it’s probably the easiest data format you can output to.

Tom

TomLiotta
 110,175 pts.