doublons

[master_student]

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

[ganeshsvm]

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

Regards,

Ganesh

[Anonymous]

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