topic Re: Incremental logic help in QlikView

Incremental logic help

madhubabum — Thu, 07 Jul 2016 11:12:55 GMT

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

Re: Incremental logic help

Chanty4u — Thu, 07 Jul 2016 11:15:46 GMT

jst add

where not Exists (ID)>0;

Re: Incremental logic help

Chanty4u — Thu, 07 Jul 2016 11:16:35 GMT

is this?

Re: Incremental logic help

madhubabum — Thu, 07 Jul 2016 11:19:52 GMT

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

Re: Incremental logic help

MK_QSL — Thu, 07 Jul 2016 11:44:17 GMT

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;