Solved

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

Posted on 2006-06-21
2
195 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

IntroductionThis article is the second in a three part article series on the Visual Studio 2008 Debugger.  It provides tips in setting and using breakpoints. If not familiar with this debugger, you can find a basic introduction in the EE article loc…
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 viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.
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.

911 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

22 Experts available now in Live!

Get 1:1 Help Now