Incremental logic help

[madhubabum]

Hi All,

I am having the following code to implement incremental logic with out date field ,

Table1:

LOAD * INLINE [

    ID, Amount

    1, 100

    2, 200

    3, 300,

  4, 401

];

Concatenate(Table1)

LOAD * INLINE [

    ID, Amount

    4, 400

    4, 402

    5, 500

    5, 502

    5, 510

] where not  Exists (ID);

OUTPUT:

ID, Amount

1, 100

2, 200

3, 300

4, 401

5, 500

Expected Result :

ID, Amount

1, 100

2, 200

3, 300

4, 401

5, 500

5, 502

5, 510     (Means we need to display table 2 records, duplicates records as well )

Regards,

Madhu

[Chanty4u]

jst add

where not  Exists (ID)>0;

[Chanty4u]

is this?

[madhubabum]

Thanks  for your reply,

ID Amount

1  100

2  200

3  300

4  401

5  500

5  502

5  510

Note : Update on table1

regards,

madhu

[MK_QSL · Accepted solution]

Table1:
LOAD *, ID as TempID INLINE [
    ID, Amount
    1, 100
    2, 200
    3, 300,
  4, 401
];
Concatenate(Table1)
LOAD * INLINE [
    ID, Amount
    4, 400
    4, 402
    5, 500
    5, 502
    5, 510
] where not  Exists (TempID, ID);
Drop Field TempID;