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?

[omid5ive]

sorry if i disturb you but in excel file we dont have number 1 but in A list i cant see 1 i just see 40 and 70

[petter]

Your orginal post actually showed a pure filtering in the example you posted. Although your title may says something else...

So what you really need is a table which contains everything that is not in one or the other table - right?

[omid5ive]

i have two table with same values

nobody cant delete any values from first table

but in some case i need to delete some values from second table

i need this deleted values. it means that i need the values from first table that they are not exist in second table

[petter · Accepted solution]

Flip the order of the two tables and then the Not( Exists(  .... logic can work as you want it to:

C:
LOAD A 
FROM
factor.xlsx
(ooxml, embedded labels, table is Sheet1)
;

A:
LOAD
  B 
WHERE Not( Exists( 'A' , B ) )
;
LOAD (RecNo() + 0) AS B
AUTOGENERATE 10
 ;

[omid5ive]

thank you petter i got my answer with your perfect help

[petter]

My Pleasure

[nizamsha]

TableA:

LOAD * Inline [

A

1

2

3

];

LOAD * Inline [

B

1

3

4

5

]Where not Exists(A,B);

DROP Table TableA;