create table with value that not match

lorenzo_gibbo — Thu, 04 Jul 2013 15:55:50 GMT

Hi,

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

EX:

TABLE A:

TABLE B:

TABLE RESULT:

E

thanks

Re: create table with value that not match

Gysbert_Wassenaar — Thu, 04 Jul 2013 16:28:17 GMT

Try:

TableA:

load *,1 as A inline [

FieldName

];

join

load *, 1 As B inline [

FieldName

];

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.