Dat cleaning and duplicate issue

[Kaustubh17]

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

[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 · Accepted solution]

@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