Comparing 2 files .CSV and getting the missing data using AS400.

pts.
Tags:
IBM DB2
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???

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following