Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
It may be that the connector is limiting this. Try changing the maximum string length parameter in the connection.
I am not sure how I can do that. Could you please guide me for the same.