Qlik returns the customer id. Can you help me?

[sevvalk]

Hello,

I am pulling data from the Erp system. Qlik adds "0" to the beginning of the customer codes I pull. How do I solve this? For example, if the customer id is 3565455, it returns 03565455. What is the reason of this?

[ManuelRühl]

I think the leading 0 is stored in the database but in the ERP-GUI the 0 is not shown.

[MatheusC]

@sevvalk 

In the data load editor, try this:

trim(ID)*1 as ID

Att,
Matheus

[vincent_ardiet_ · Accepted solution]

You can also force the format to numeric when you load:
load ...
num(customer_id) as customer_id,
...

[MatheusC]

@sevvalk 

The subject of the topic being resolved, close the topic with the solution found.

Thanks,
Matheus