App Development

[jchacko_rxsense]

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.

[Lisa_P]

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

[jchacko_rxsense]

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