Solved

comparing 2 columns of two files, then do substraction if 2 columns equal

Posted on 2006-06-21
2
194 Views
Last Modified: 2010-04-01
Hi experts,

Two files, file1, file2

file1
Store id          sale amt
123               100
234               200
345               300


file2
store id          sale amt
345               50
123               60
234               70

What I want to do is comparing the store id,
if (file1.store id == file2.store id)
then file1.sale amt - file2.sale amt

so the correct results should be
store id   sale increase
123         40
234         130
345         250

But I got wrong results like
store id   sale increase
123        150
234        140
345        230


I use
set<string> stores
string file1storeid=file1.store id
string file2storeid=file2.store id
stores.insert(file2storeid)
if (stores.find(file1storeid) == stores.end()))
{
file1.sale amt - file2.sale amt
}

Please help - Thanks
0
Comment
Question by:justinY
2 Comments
 
LVL 17

Accepted Solution

by:
rstaveley earned 125 total points
ID: 16964860
Try using the store id  as a key to a map.

e.g.

typedef string StoreId;
typedef double SaleAmount;
typedef map<StoreId,SaleAmount> Database;

Database db;

// Process file 2 first
while (/* read record from file */) {

    StoredId storeId = /* */;
    SaleAmount saleAmount = /* */;
    db[storeId] = saleAmount;
}

// Then process file 1
while (/* read record from file */) {

    StoredId storeId = /* */;
    SaleAmount saleAmount = /* */;
    db[storeId] -= saleAmount;  // Subtract the sale amount - database now stores the difference
}

// Then generate the report, by iterating through the database

for (Database::const_iterator itr = db.begin();itr != db.end();++itr) {

    const StoredId& storeId = itr->first;
    const SaleAmount& saleDifference = itr->second;
    cout << /* */;
}
0
 

Author Comment

by:justinY
ID: 17004970
Thank you so much. It works
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction This article is a continuation of the C/C++ Visual Studio Express debugger series. Part 1 provided a quick start guide in using the debugger. Part 2 focused on additional topics in breakpoints. As your assignments become a little more …
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
The goal of the tutorial is to teach the user how to use functions in C++. The video will cover how to define functions, how to call functions and how to create functions prototypes. Microsoft Visual C++ 2010 Express will be used as a text editor an…
The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now