Match function

[David_K]

Good Morning fellow Qlik Sense users.

I have been looking at some previous questions / answers around using the MATCH function, but cant seem to be able to get them to work.

I have 2 sets of data of around 900k rows in a single column, and I need to be able to see if data from Data Set 2 (Sep_22) matches data in Data Set 1 (Jan_22) 

In Excel I would use the following

MATCH(A2,'SEP_22.csv'!$A:$A,0)   -  In this formula "A2" refers to the data in the  "Jan-22" data set

From this I can then identify the number of items that remain in the SEP_22 table and report on this, but I can't get MATCH to work here.

Any help, guidance would be greatly appreciated.

Thanks in advance,

David 

[Mark_Little]

Hi

Match() In Qlik allows you to pick out a number of choices for a single field, with stops you having to write long or statements and not if a field value in one dimension matches a field dimension in another.

Here i would probably looking to do something in script to find this, probably with some from of join or applymap, but would need more info on the data to assist more

[David_K]

Thanks for the reply Mark,

the data I need to check on is a range of parts that have either been superseded or discontinued against the current range of parts.

In Jan_22 we had approx. 811k references, which has since grown to over 1.1m references - we need to be able to see what refences have not changed, and remain from base data from January.

Unfortunately, I cannot provide data due to confidentiality requirements and file size.

Hope this helps