Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
jchacko_rxsense
Contributor III
Contributor III

Increase Size of Column in DataLoadEditor

I am loading my data from SQL server to Qlik. When I load, one of columns does take in the entire length of original data it cuts it of in between.

 

Is there a way to take in the entire string.

 

Code:

Table_raw:
LOAD
Chr(39) & LogicID & chr(39) as LogicID,
Chr(39) & QvdID & chr(39) as QvdID,
Chr(39) & SourceColumn & chr(39) as SourceColumn,
Chr(39) & SqlQlikAlias & chr(39) as SqlQlikAlias,
Chr(39) & ConsensusAlias & chr(39) as ConsensusAlias,
Chr(39) & CalculationType & chr(39) as CalculationType,
Chr(39) & CalculationLogic & Chr(39) as CalculationLogic,
Chr(39) & ALTERUSER & chr(39) as AlterUser
;
SQL
SELECT
LogicID
,QvdID
,SourceColumn
,SqlQlikAlias
,ConsensusAlias
,CalculationType
,CalculationLogic
,ALTERUSER
FROM MyTable
;

 

In the above code my Calculation Logic is not being loaded completely. It gets cut of after 259 characters.

 

Labels (1)
2 Replies
Lisa_P
Employee
Employee

It may be that the connector is limiting this. Try changing the maximum string length parameter in the  connection.

jchacko_rxsense
Contributor III
Contributor III
Author

I am not sure how I can do that. Could you please guide me for the same.