Compare value from two xlsx files

[StefanDjukic]

Hi All, 

I'm new at using QlikView, I have used PowerBI on my Faculty. But now in the company, we using QlikView and I got a strange question from my TL is it possible to use QlikView as a QC tool. For example, what we need is to compare two Excel files one file will be a reference file and one will be an update file. So what I need is to check if similar data have inside reference files as in the update file by the column name. Ex: 

Ref file: Category , Name product          Update file:  Category , Name product
 Value:   Toy           , Some toy                                Value:   toey             , Some toy 2


Here I will need to mark like a toey is not the same as Toy in Ref file. But I will only need to mark toey and say here something not right. 

The main question is this something possible to do in QlikView? And if it possible how? 😄 

I hope you will understand what I need.

Best regard.

Stefan.

[chrismarlow · Accepted solution]

Hi,

You probably could do something with QlikView, but I am not sure it would work very well.

If you are on the right version of Office I would just look at the MS tools to do what you describe though, see;

Compare two versions of a workbook by using Spreadsheet Compare - Office 365 (microsoft.com)

Cheers,

Chris.

[StefanDjukic]

Hi,

Thank you very much for your advice, I didn't know this exists. I will have a look 😄 

Cheers,

Stefan.

[chrismarlow]

Hi,

I hope it works Ok.

Small confession, despite having been around a while and sometimes being referred to as an 'Excel guru' (always by other people, never myself). I only actually found this over the summer when I was asked to write some VBA to do validation for testing 😁.

Cheers,

Chris.

[StefanDjukic]

Hi,

Thanks, it helps with some work but some need to be inside QV. Again big thanks. 

Yes, it's always good to know some software, it will come a time when you need to use it.

Best regards. 

Stefan.