how to eliminate the repeated values

[AbdulHaseebKhan]

input:                    output:

january               january

 january              february

february            march

march

march

[MendyS]

Hi @AbdulHaseebKhan 

try to use with this  in the data load editor ( script) - 
"
Load Trim(Input) as Month
Group by Trim(Input)
resident TestTable
" 

let me know if that is what you want 
thanks

[AbdulHaseebKhan]

Hi

[justISO]

Hi, when loading add DISTINCT after LOAD, this way you will load only unique values. For example:

LOAD DISTINCT

your_field, your_field

FROM ...