Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tiklam_dynasys
Contributor

Data Type Issue on Data Load Editor and Data Manager

Hi All,

I have an issue that the data type is different when using Data Load Editor and Data Manager.

I store the table with below script:

TableA:

Load

text(Value) as Value

From [.....]

Store * from TableA into [...../TableA.qvd];

Example of Value:3261-1-01

When I use Data Load Editor, it works fine.

When i use Data Manager, it auto converts the Value to date format which i dont want.

Is it possible to prevent the issue happen in storing qvd process?

Best Regards,

Louis

6 Replies
OmarBenSalem
Esteemed Contributor

Re: Data Type Issue on Data Load Editor and Data Manager

Which version of Qlik Sense you're using?

tiklam_dynasys
Contributor

Re: Data Type Issue on Data Load Editor and Data Manager

3.1 SR3

arvind_patil
Valued Contributor III

Re: Data Type Issue on Data Load Editor and Data Manager

Hi Louis,

Which format you want.

Thanks,

Arvind Patil

tiklam_dynasys
Contributor

Re: Data Type Issue on Data Load Editor and Data Manager

just showing original text: 3261-1-01

tiklam_dynasys
Contributor

Re: Data Type Issue on Data Load Editor and Data Manager

Any Idea?

jenyakoro
New Contributor

Re: Data Type Issue on Data Load Editor and Data Manager

Try use function text()

Community Browser