topic doublons in QlikView

doublons

master_student — Mon, 06 Feb 2017 10:36:43 GMT

Hello Guys,

I hope this finds you very well.

I have two rows in my dashbord that are exaclty the same. This two rows are comming from two different data bases. I have a flag field to detect that STC or POSA

If i have exactly the same rows, I would like to display only row coming from posa database

any idea how to do that? here's an example :

Thank you

Re: doublons

ganeshsvm — Mon, 06 Feb 2017 11:03:56 GMT

We can better help you with some sample data, of your requirement.

Regards,

Ganesh

Re: doublons

Anonymous — Mon, 06 Feb 2017 11:14:45 GMT

Hi,

You can load first the data from POSA and then the data from STC using the where clause Exists. You have to put all the common fields concatenated in other field and with not exist not loading those record. For example:

POSA:

LOAD * Inline

[DATA,AMOUNT,CLIENT,ID

12/12/2016,12,Maria,1

12/01/2016,13,Marcel,2

];

tmp:

LOAD *, DATA&AMOUNT&CLIENT AS DATA_AMOUNT_CLIENT

Resident POSA;

DROP TABLE POSA;

CONCATENATE(tmp)

LOAD * Inline

[DATA,AMOUNT,CLIENT,ID

12/01/2016,13,Marcel,1

13/01/2016,13,Marcel,32

]

WHERE NOT Exists (DATA_AMOUNT_CLIENT,DATA&AMOUNT&CLIENT);

Best regards,

Cosmina