Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
abhinavbose
Contributor III

How to compare rows from two excel sheets

Friends,

I have a requirement like,

1. I want to compare two excel sheets having 7 columns or conditions. It can have many fields in it, many fields can have same names but with different field IDs having 7 different conditions for them. I need to compare a row in the same excel sheet / different excel sheet and split the fields as "Reused fields" and "New fields".

Plz guys help me to do this....

6 Replies
ahaahaaha
Honored Contributor

Re: How to compare rows from two excel sheets

Hi,

Can we see a fragment of your original data and the result that you want to get?

Regards,

Andrey

abhinavbose
Contributor III

Re: How to compare rows from two excel sheets

Thanks for your reply Andrey, Plz find the attachment from my original discussion. I want the fields to be grouped based on the business grouping but it should satisfy all the conditions (Qualifier/Enumeration,Data type,Min occurs,Max occurs,M/C/O and Length).

ahaahaaha
Honored Contributor

Re: How to compare rows from two excel sheets

Operator Distinct groups lines 6 and 7 of your source file

LOAD Distinct

...

From ...

Must you combine the values of "Academic Information" in the field "Business Group"?

1.jpg

If not, then DISTINCT solves the task on a sample of the original data.

Regards,

Andrey

laddu_927
Valued Contributor

Re: How to compare rows from two excel sheets

Why cant we load distinct rows??

using some work arounds like firstvalue() (because using distinct is not appreciated always.)

abhinavbose
Contributor III

Re: How to compare rows from two excel sheets

Guys,

I also wanted to compare those conditions based on their field names

(Qualifier/Enumeration,Data type,Min occurs,Max occurs,M/C/O and Length).

How to do that one, plz help me with that?

yoganantha321
Contributor II

Re: How to compare rows from two excel sheets

Hi Bose,

Why can't you try with group by while extracting from source file.