If statement to isolate a match

[#1]

Hi

I have two document with a id say Car Reg Number, I've tried different statements but can't get i right. How can i isolate all reg numbers that occurs in both documents?

So if a reg number is in sheet1 and sheet 2 isolate this number,

any tips?

thx

Theo

[Anonymous · Accepted solution]

not sure what you exactly want

using exsits could get you those datasets whichexists in both dos

Doc1:

load *

resident File1

Doc2:

noconcatenate load *

resident File2

where exists (Car Reg Number)

for correct syntax please check help or provide an example  app

[#3]

Hi

Im new to qlikview it your tip pointed me to the answer and solved my problem. Thank you..

//Theo