Unique Values

Question

Hi Team,

I hope you are doing well :)

I have a below table

CategoryCodesDept CodeRoll noPrevios monthAmountCode + Dept CodeSTDABCDCA12 -183.14ABCD CASTDABCDCA12 -183.13ABCD CASTDPQRSHR13 183.14PQRS HRSTDPQRSHR14Dec-Jan-Feb'25185.13PQRS HRSTDWXYZCA13Dec-Jan-Feb'25-194648.44WXYZ CASTDWXYZCA13Dec-Jan-Feb'25194648.44WXYZ CA

where i have concatenate a column based on field Codes and Dept code and called the new column as Codes + dept Code

Now for each unique values for column  Codes + Dept Code i have to test whether previous month column value is blank or zero and if it is blank or zero i have to check another Codes + Dept Code unique value.

for other than blank or zero values in previous month column i have to check the maximum value in amount column and populate that records into output file.

Many Thanks in advance!!

binu_acs · Answer

@sneha_bhiwagade1 one way of doing this

unique_values_08122025.yxmd

sneha_bhiwagade1 · Answer

Hi,

@binu_acs  below is the expected output

Category Codes Dept Code Roll no Previos month Amount Code + Dept Code

STD PQRS HR 14 Dec-Jan-Feb'25 185.13 PQRS HR

STD WXYZ CA 13 Dec-Jan-Feb'25 194648.44 WXYZ CA

Thanks

binu_acs · Answer

@sneha_bhiwagade1 Can you provide the expected output?