difference between two table

[omid5ive]

hi

i have two table like below :

A
1
2
3

B
1
3
4
5

i want two have difference of this two table like blow:

C
4
5

how can i do this?

[Kushal_Chawda]

TabA:

Load A

From TableA;

TabB:

Load B

From TableB

where not exist(A,B);

Drop table TabA;

[omid5ive]

hi

i attached my file with your solution but it cant show anything

[petter]

You have to fix your load script and write this:

WHERE Not( Exists( 'Factor_Number1' , number ) ) ;

You were missing paranthesis ( ) for the Not()-function and you have to quote the field name 'Factor Number1' with single quotes...

[petter]

[omid5ive]

i think i cant use not exist with auto generate command.

is it true?

cause when  create A table in excel i can get correct answer with your solution

[petter]

QlikView when it performs the Exists()-function does not care if the field it checks against (the first parameter) is originally populated by and AutoGenerate. The AutoGenerate populates a table with one or more fields and these fields are on the following script statements first-class fields without any restrictions or limitations compared to any other fields which comes from other sources...

So the answer must be ... the problem is elsewhere

[omid5ive]

sorry

can you check my attached document?

[petter]

Your code is working as expected in my eyes. The AutoGenerate makes an exclusion list of ten numbers from 1 to 10 and the Excel file is containing numbers within that range so nothing will be let through the "filter".

If you change one or more of the values to be outside the range 1..10 then you will see that it works - and works as expected. At least what I thought you expect from what you told us.

[petter]

Here are updated attachements