ques

[Dolly123]

how to remove spaces in this column ? in qliksense

[albertovarela]

Assuming all valid values are numeric, you could add the following where clause to your load statement

Where IsNum(Office)