Dat cleaning and duplicate issue

Hi team,

I have the below filtered data,

As you can see reparative values. how to get the accurate unique condition. i had also used unique tool but its giving me wrong result for other data. . Seeking for support

Regards,

kaustubh

Workflow

Transformation

Accepted answers

BRRLL99

@Kaustubh17

Hi , As per ypur main input from column SP to tot Act Qty all the values are same

Can you explain what do you mean by accurate unique condition??

Your expected output has sahoo enterprises, i don't see it in input data

All comments

atcodedog05

Hi @Kaustubh17,

Can you provide us the expected output to replicate?

Kaustubh17

Hi @atcodedog05 Below is the kind of expected output

Quarter	Month	Region	SP	SH	Customer Name	Total Amount	Quantity	Total quantity	Ratio Based Amount
1-4-2024 to 30-6-2024	Apr	EAST	7E+06	7000004	SAHOO FERTILISERS	50	50	120	20.83
1-4-2024 to 30-6-2024	May	EAST	7E+06	7000004	SAHOO FERTILISERS	50	30	120	12.50
1-4-2024 to 30-6-2024	Jun	EAST	7E+06	7000004	SAHOO FERTILISERS	50	40	120	16.67

Best Regards,

Kaustubh

BRRLL99

@Kaustubh17

Hi , As per ypur main input from column SP to tot Act Qty all the values are same

Can you explain what do you mean by accurate unique condition??

Your expected output has sahoo enterprises, i don't see it in input data

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703