Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.