topic Re: How to do it in QLIKVIEW in QlikView

How to do it in QLIKVIEW

Anonymous — Fri, 29 Nov 2013 09:22:00 GMT

I have an excelsheet with 3 fields.

ID,Sequence and businessarea.

ID have 233304 records and sequence and businessarea have 30212 records.

In Sequence and businessarea i need to match the records . For matched records it has to display as Matched and for non matched records it has to show Not matched.

we can do this in excel sheet using formula

=IF(ISERROR(MATCH(B:B,A:A,0)),"No Match","Match")

but in qlikview how to do it?

I have attached the excel what we did in Excel..PFA

Re: How to do it in QLIKVIEW

Fri, 29 Nov 2013 09:37:16 GMT

Hi Rammohan,

you can do this in script.

Load ID,Sequence,businessarea,if(Sequence=businessarea,'Match,'NoMatch') as Flag .

Thanks,

Shruthi

Re: How to do it in QLIKVIEW

amars — Fri, 29 Nov 2013 09:40:16 GMT

Hi Ram,

Please find attached file.

Thanks...

Re: How to do it in QLIKVIEW

Fri, 29 Nov 2013 09:42:55 GMT

Hi,

Load the file in a temp table

Use the exists() function to load the Definitive table.

temp:

Load * from ...

Definitve:

Load *, if (exists(BSN_RHSP..., SEQUENCE), 'MATCH, NO MATCH') resident Temp;

drop table Temp;

Fabrice

Re: How to do it in QLIKVIEW

Anonymous — Fri, 29 Nov 2013 10:23:56 GMT

Thanks a lot Fabrice...its working fine.....

Re: How to do it in QLIKVIEW

Fri, 29 Nov 2013 10:33:32 GMT

Excellent,

Tag it as answered then

Fabrice