Duplicate rows

[pawwy1415]

Hi,

We are getting duplicate rows for couple of metrics, e.g. Mt15 and Mt16 is showing against two group A and B but it should show only against A, rest of the metrics are showing against correct group. could you please help what expression we can use to eliminate duplicate rows.

Wrong value

Expected - it should like below

[tomasz_tru]

How do we know it should go to group A not to B?

Tomasz

[pawwy1415]

through original data feed.. this should only show for A.

[Anonymous]

Hi ,

see this snapshot

Regards,

Sahadev

[pawwy1415]

where we should add this logic?

[pawwy1415]

we don't to derive new column..

[pawwy1415]

expression is giving error as well

[pawwy1415]

expression work, but stil giving two rows.

[tomasz_tru]

If it's always A, B's should be removed on data load stage.