How to do it in QLIKVIEW

[Anonymous]

Hi

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

[#2]

Hi Rammohan,

you can do this in script.

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

Thanks,

Shruthi

[amars]

Hi Ram,

Please find attached file.

Thanks...

[#4 · Accepted solution]

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

[Anonymous]

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

[#6]

Excellent,

Tag it as answered then

Fabrice