Count Value Under One Column

[danieldors]

Hello,

I currently have one column with case numbers, and would like another which would tell me how many times that case is under the first column, in essence flagging me duplicates. Thank you.

[Ahidhar]

use count distinct

[Alexan02]

Hola! 

Si quieres envíanos un caso práctico para entender el problema de manera visual y así podremos ayudarte mejor.

Gracias, un saludo.

[sidhiq91]

@danieldors  Please use the below script:

NoConcatenate
Temp:
Load * Inline [
Case_Number
111
111
112
113
112
114
115
115
];

NoConcatenate
Temp1:
Load Case_Number,
count(Case_Number) as Total_Case_Number
Resident Temp
group by Case_Number;

Drop Table Temp;

Exit Script;

If this resolves your issue, please like and accept it as a solution.