topic Re: Compare value from two xlsx files in QlikView

Compare value from two xlsx files

StefanDjukic — Tue, 22 Dec 2020 08:13:12 GMT

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.

Re: Compare value from two xlsx files

chrismarlow — Tue, 22 Dec 2020 15:03:24 GMT

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.

Re: Compare value from two xlsx files

StefanDjukic — Wed, 23 Dec 2020 08:04:34 GMT

Hi,

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

Cheers,

Stefan.

Re: Compare value from two xlsx files

chrismarlow — Wed, 23 Dec 2020 11:11:37 GMT

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.

Re: Compare value from two xlsx files

StefanDjukic — Wed, 23 Dec 2020 13:55:18 GMT

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.