Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to find out the Datatype of column names in the Qliksense

Hello everyone,

I have one Question

i am just loading the data from Database and storing into the QVD.

It is generating code like below :

select

"Column Name"

from table1

my question is if it is in " "(double codes) is it going to take memory little big, else it will take more memory without double codes

and please let me know how to find out the datatype of the column name in the Qliksense

Thanks in advance

Regards

Sreeharsha V

Tags (1)
1 Reply
MVP
MVP

Re: How to find out the Datatype of column names in the Qliksense

First of all the double quotes does not make a difference as to how the column is converted into a field in Qlik. It is only for making sure that if you have special characters in your column name that Qlik is able to delimit the column name.

That is why I prefer to use [  and  ]    instead of   "   because it is more obvious that you are quoting a name for an entity like a field name, column name, variable name that has characters in it's name that might confuse Qlik if not quoted. It does not change the values going into the field.

Secondly - if you need to have detailed information about data types for columns in the database source there are three quick table loading shortcuts that can be use in a load script like this:

SQLTables:

SQLColumns:

SQLTypes:

Yes - exactly like that ... Line #1 will load a table with information of all tables for the current connection (SQL).

Line #2 will give you a table with all the columns and associated information.

Line #3 will give you a table of all the data type information relating to the columns and the tables....

Extremely handy - if you need it - but often overlooked - I think...

Community Browser