topic Re: Unique values (deduplication) in App Development

Unique values (deduplication)

zela9123 — Mon, 20 Dec 2021 21:08:46 GMT

Hi All,

I am struggling with the following task in Qs.

As is:

Reference No.	Status
A001	low
A001	medium
A001	high
A001	low
A002	medium
A002	medium
A003	high
A003	high

To be:

Reference No.	Status
A001	low
A001	medium
A001	high
A002	medium
A003	high

My input table contains duplicated statuses for the same reference number. I would like to present unique statuses for each reference number, so I could show percentage breakdown chart.

I look forward to hearing from you.

Re: Unique values (deduplication)

Taoufiq_Zarra — Thu, 21 May 2020 23:09:06 GMT

Maye be :

Data: load distinct * ; LOAD * INLINE [ Reference No.,Status A001, low A001, medium A001, high A001, low A002, medium A002, medium A003, high A003, high ];

Re: Unique values (deduplication)

zela9123 — Sun, 24 May 2020 08:39:37 GMT

Hi,

Thanks, but I would like to use the formula in expression, when I am creating bar chart (there are corresponding data for those which are duplicate and I will need them for another analysis, so I do not want to 'loose' it).

As a dimension I would use 'Status', and I need to find expression which will remove duplicates from those 2 columns.

Regards,

Zela

Re: Unique values (deduplication)

Saravanan_Desingh — Sun, 14 Jun 2020 17:36:50 GMT

I am still trying to understand your requirement. I might be wrong.

You can simply add both of them in the Dimension to get the Unique. Though you see the unique, still the aggregation expression will be applicable to all data.

If I need to understand more on your requirement, can you share your Expression which you are trying.

Re: Unique values (deduplication)

Kushal_Chawda — Sun, 14 Jun 2020 21:19:12 GMT

As you are using status as a dimension, you can simply use the below expression to remove duplicates

=Sum(distinct Value)

If it is not working please share the sample data with expected output