Qlik DataTransfer --> Load key fields with leading zeros

[SamKng]

Dear all,

As described in the following knowledge base article, it's important to use text() when dealing with key fields containing leading zeros:

https://community.qlik.com/t5/Official-Support-Articles/Leading-zeros-are-missing-in-loaded-data-val...

That has worked pretty well in our on-prem Qlik Enterprise landscape. 

As we're now moving to Qlik Cloud, we'd like to use Qlik DataTransfer to load certain on-prem data and upload the corresponding QVD's to Qlik Cloud. However: How can we overcome the issue with the leading zeros if Qlik DataTransfer does not allow us to edit the load statement (to add the text()-formula to the key field)?

Any hints are highly appreciated.

Best regards, Sam

[marcus_sommer]

You may try to apply an appropriate pre-load for the field to define the interpretation, maybe something like this:

Dummy: load '0' & recno() as KeyField autogenerate 9;

...
YourScript;
...

drop tables Dummy;

The autogenerate is just an example and such load might be come from any external source.

[SamKng]

Dear Marcus,

Thanks for sharing your thoughts. However, my problem is that Qlik DataTransfer does not offer any possibility (at least not to what I know) to enter any code. It just loads a selected table/view (in my case a SAP HANA calculation view) and stores it in a QVD (which is then uploaded to Qlik Cloud). 

As I've not received any other answers, I assume that the only option is to fix that directly at the source by adding a prefix to the dimension values with leading zeros. 

Best regards

[marcus_sommer]

I don't know the tool Qlik DataTransfer. If it's some kind of a "closed" tool you may really have no options to add any customized script-code but if it worked in the way of the classical connectors the above suggested may be applicable because it doesn't touch the load itself else it is aimed to influence the interpretation of the data with already loaded data.

If it's not adjustable on this way you may look if there are any configurations of the DataTransfer. I could imagine that there are options to react and to change the data-type of the fields.

If not you may adjust the data later by loading from the QVD's by considering the target-lengths and adding with it the missing zeros/spaces.