Increase Size of Column in DataLoadEditor

jchacko_rxsense — Sat, 10 Sep 2022 10:16:59 GMT

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.

Re: Increase Size of Column in DataLoadEditor

Lisa_P — Sun, 11 Sep 2022 23:27:47 GMT

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

Re: Increase Size of Column in DataLoadEditor

jchacko_rxsense — Mon, 12 Sep 2022 05:52:44 GMT

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

topic Re: Increase Size of Column in DataLoadEditor in App Development

Increase Size of Column in DataLoadEditor

Re: Increase Size of Column in DataLoadEditor

Re: Increase Size of Column in DataLoadEditor