topic Re: Same field 2 data types in App Development

Same field 2 data types

dmnab1 — Fri, 05 Jan 2024 19:41:00 GMT

Hi all,

I've got the following question, I have a table that has a field with numbers with the following formatting:
00001233 (data coming from Salesforce).

When I execute this

Lib Connect to 'Salesforce'; InvoicesTmp: LOAD Id Select Id FROM Invoices;

I got this

So two values: 00003945 and 00003960

However when I use that table in resident like below:

Invoice: NOCONCATENATE LOAD * Resident InvoiceTmp; Drop Table InvoiceTmp;

Qlik recognizes some values as text and others as number

What's the reason behind this? It's causing problems for me when linking tables, as the IDs can be in the format 00003414 or 3414. Both formats are valid, but they belong to different data sources.

Thanks!

Re: Same field 2 data types

Oleg_Troyansky — Fri, 05 Jan 2024 19:56:18 GMT

Hi,

It's hard for me to explain why this is happening - this is deep under the hood of Qlik, but I'd recommend using the function text() for your Id fields, to preserve the original format with the leading zeroes. This way, 00003414 and 3414 will remain separate:

LOAD

text(id) as id
...
Cheers,

Re: Same field 2 data types

dmnab1 — Mon, 08 Jan 2024 12:48:19 GMT

Hi Oleg, thanks for your quick response.

Yes, that is what I'm gonna do.

Cheers