Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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?
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
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
;
thank you petter i got my answer with your perfect help
My Pleasure
TableA:
LOAD * Inline [
A
1
2
3
];
LOAD * Inline [
B
1
3
4
5
]Where not Exists(A,B);
DROP Table TableA;