topic Re: A problem with a text field in QlikView

A problem with a text field

Mon, 23 May 2016 11:17:47 GMT

Hello to all,

I have the following problem:

I load a table from a SQL Server text field whose length reaches to 1000 characters

When I export to Excel the field is filled with '###### characters'

Why is this happening? Is there a way to say that the length of the field can be up to 1000 characters?

Thank to all

Re: A problem with a text field

Kushal_Chawda — Mon, 23 May 2016 11:21:48 GMT

You can try loading like below

LOAD *,

trim(mid(Field,1,1000)) as Field

.....

FROM table

Re: A problem with a text field

sujeetsingh — Mon, 23 May 2016 11:28:04 GMT

Convert it in SQL itself

Re: A problem with a text field

Mon, 23 May 2016 11:43:57 GMT

Thank you

but it does not work.

I felt when unloading the table from SQL servere to put the statement

LTRIM (SUBSTRING (DO30_DESCART, 1.1000)) AS DO30DESCART

but not work.

Re: A problem with a text field

marcus_sommer — Mon, 23 May 2016 11:44:04 GMT

The '###### characters mean only that the content didn't fit within the column-width. So you have the possibility to extend the column-width and/or the row-height and/or to enforce a line-breaks. Did you have anywhere a problem with this in qlikview?

- Marcus

Re: A problem with a text field

Mon, 23 May 2016 12:32:06 GMT

No, I had this problem only on some lines.

It can be a character ASCII particular?

If yes, how can I find out which is it?

Re: A problem with a text field

Anil_Babu_Samineni — Mon, 23 May 2016 12:50:36 GMT

Marino,

Can you please check the length of Each cell / Share that Excel..

LEN(Text of Cell) -- LEN(A2)

Please Find that, Length is came or not. So that we can get idea of that...

Updated : I have 2740 Characters. Such time you have to select the column and then WrapText.

You will get idea... Please find Attachment ...

Re: A problem with a text field

marcus_sommer — Mon, 23 May 2016 13:02:14 GMT

If I'm not sure about some characters I copy them within a editor like notepad ++ to check if there is anything noticeable.

- Marcus

Re: A problem with a text field

Mon, 23 May 2016 13:10:44 GMT

Bay Anil.

Ok.

If I understand it.

the length of some fields oh the tble QVW and if it works export to Excel:

length Yes/No

95 yes

49 yes

40 yes

244 yes

513 no

353 no

250 yes

390 no

91 yes

106 yes

152 yes

118 yes

66 yes

141 yes

Re: A problem with a text field

Mon, 23 May 2016 13:22:39 GMT

Hello Anil .

Yes, so it works. I tried it once.

Then, in your opinion, the problem is in Excel and not QLW?

Thank

Re: A problem with a text field

Anil_Babu_Samineni — Mon, 23 May 2016 13:27:05 GMT

Marino,

I just create the one QVW with one listbox. Each row has 3500 Characters. After that, i just send that data to excel.. And then i got same problem after that i select the whole column and then I click the Wrap Text. In my machine, It's work..

So, this is not a problem with qvw....

Re: A problem with a text field

Anil_Babu_Samineni — Mon, 23 May 2016 13:38:22 GMT

Marino,

Are you clarify this..

If yes, Please close this Thread .... Or else Please raise the issue ...

Re: A problem with a text field

Mon, 23 May 2016 14:14:28 GMT

OK.

Thank 1000 to all.

...this is not a problem with qvw...

I would bet

Thank