topic Re: Qlik Truncate String Length in App Development

Qlik Truncate String Length

isaiasdd92 — Tue, 20 Aug 2024 12:39:53 GMT

Hello!

I have a connection with Databricks, where I have a table with the geographic coordinates of Brazilian states.

However, this data is a string with many characters, and Qlik is only loading 255.

Is there any way around this?

I have already set the connection parameter to 16384 as the maximum string size, but it continues to get 255.

Re: Qlik Truncate String Length

marksouzacosta — Tue, 20 Aug 2024 18:23:54 GMT

Hi @isaiasdd92,

Can you please provide the following:

Confirm if your data looks correct in Databricks
What is the field type and length in Databricks?
What is the Qlik Data Connection you are using to connect to Databricks?
Can you please Share your Load Script?

Regards,

Mark Costa

Re: Qlik Truncate String Length

Raju_6952 — Wed, 21 Aug 2024 06:31:43 GMT

Hi @isaiasdd92 ,

instead of databricks connection can you crearte odbc connection and setup paramaters for chracters

length which you can extened as per your choice.

we also faced this challenges while loadaing the data from feedback reviews for the products which is more than 255 characters length.

Suggestion: We used simba spark odbc driver for our requirement.

Regards,

Siva Prasad

Re: Qlik Truncate String Length

isaiasdd92 — Tue, 10 Sep 2024 16:35:11 GMT

Hi @marksouzacosta

1 - Yes, my data is correct in Databricks.

2 - Data type is string and not have a length in Databricks.

3 - I using a Databricks Connector in Qlik Sense SaaS, in Databricks I use a SQL Warehouse Serveless

4 - Sure, it's simples, just a script load a table from Databricks contains a Geolocation from states of Brazil.

UFs: LOAD KeyUF, SiglaEstado, IndicadorDivisaoAtendimentoCDs, AreaEstado, CoordenadasGeograficasEstado, RegiaoUFTramontina, CodigoPais, DescricaoUnidadeFederacao, RegiaoEstado; SELECT KeyUF, SiglaEstado, IndicadorDivisaoAtendimentoCDs, AreaEstado, CoordenadasGeograficasEstado, RegiaoUFTramontina, CodigoPais, DescricaoUnidadeFederacao, RegiaoEstado FROM `adm_sit_gold_prd`.masterdata.`dim_uf`;

Re: Qlik Truncate String Length

isaiasdd92 — Tue, 10 Sep 2024 16:35:12 GMT

Hi @marksouzacosta

1 - Yes, my data is correct in Databricks.

2 - Data type is string and not have a length in Databricks.

3 - I using a Databricks Connector in Qlik Sense SaaS, in Databricks I use a SQL Warehouse Serveless

4 - Sure, it's simples, just a script load a table from Databricks contains a Geolocation from states of Brazil.

Re: Qlik Truncate String Length

isaiasdd92 — Tue, 10 Sep 2024 16:38:06 GMT

Hi @Raju_6952

I am using a Qlik Sense SaaS, not have a option to ODBC Connection.

Re: Qlik Truncate String Length

isaiasdd92 — Tue, 17 Sep 2024 11:05:28 GMT

Hello!

I resolved the problem following the instructions in this link.

https://community.qlik.com/t5/App-Development/Does-column-length-in-SQL-SF-table-matter-when-reading-data-into/m-p/2040442/highlight/true#M85726