Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
Table_raw:LOADChr(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;SQLSELECTLogicID,QvdID,SourceColumn,SqlQlikAlias,ConsensusAlias,CalculationType,CalculationLogic,ALTERUSERFROM 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.