Qlik Sense is adding zeros to importet values

[Oliver1]

Hello everybody,

Qlik Senes is adding zeros to some of my imported values, I have an example below which shows the item_id. The item_id should only be 7 or 8 digits long. How can I prevent this?

The source is a csv file.

Thank you very much and br,

Oliver

[sunny_talwar]

May be try loading it like this

Num(Replace(LTrim(Replace(item_id, '0', ' ')), ' ', '0')) as item_id

[Oliver1]

@sunny_talwar  it's working, thank you!