create table with value that not match

[lorenzo_gibbo]

Hi,

how can I create a table with the values ​​from other two, but only  with the value that not match?

EX:

TABLE A:

A

B

C

TABLE B:

A

C

D

E

TABLE RESULT:

B

D

E

thanks

[Gysbert_Wassenaar]

Try:

TableA:

load *,1 as A inline [

FieldName

A

B

C

];

join

load *, 1 As B inline [

FieldName

A

C

D

E

];

Result:

Load FieldName

Resident TableA

where A <> B;

//optional: drop table TableA;

If you mean to that you want to create this as a straight table in the UI then look at this discussion.