topic Re: Wrap Text in Script Editor in QlikView

Wrap Text in Script Editor

shane_spencer — Thu, 06 Jul 2017 10:53:33 GMT

In script editor when I load a table by selecting 'Data from Files' and 'Table Files' the Fields are wrapped instead of each field being on a new line. I found this topic Wrap Text in Script Editor‌ from 2009 but cannot see an option to select Column, Row or Structured. Can anyone advise how to fix?

Re: Wrap Text in Script Editor

ahaahaaha — Thu, 06 Jul 2017 11:00:30 GMT

Hi,

Try to work with these settings before downloading the file

Regards,

Andrey

Re: Wrap Text in Script Editor

Kushal_Chawda — Thu, 06 Jul 2017 11:14:35 GMT

which file you are loading? if it is text file, you need to select the correct delimiter

Re: Wrap Text in Script Editor

BalaBhaskar_Qlik — Thu, 06 Jul 2017 12:40:22 GMT

This is what you are looking for:

Re: Wrap Text in Script Editor

shane_spencer — Thu, 06 Jul 2017 12:41:59 GMT

It doesn't matter the file type, the fields are being wrapped rather than each field being on the next row. I've previously been using QV11 and now I've got a new laptop with QV12. I've never seen this before and cannot find the setting to change it

Re: Wrap Text in Script Editor

shane_spencer — Thu, 06 Jul 2017 12:44:38 GMT

When I select Connect I get the following window, not the view you have provided.

Re: Wrap Text in Script Editor

BalaBhaskar_Qlik — Thu, 06 Jul 2017 12:52:01 GMT

By Clicking Connect we want to establish a connection to one of the Database(Then you can see the above screen, that what you mentioned), Later we'll select the particular Database, then only you'll see a Screen that what i was attached. From there you need to modify the options.

So try to connect a Database & select that database.

Re: Wrap Text in Script Editor

shane_spencer — Thu, 06 Jul 2017 13:09:52 GMT

I've not got a Database to connect to. I'm working with excel files and QVD's.

Re: Wrap Text in Script Editor

BalaBhaskar_Qlik — Thu, 06 Jul 2017 13:26:07 GMT

If you're working with xls, xlsx, qvd files then you've to select from: Header Size & Labels options.

Re: Wrap Text in Script Editor

shane_spencer — Thu, 06 Jul 2017 13:50:09 GMT

There's nothing there to change the format of the script from wrapping.

Re: Wrap Text in Script Editor

shane_spencer — Fri, 07 Jul 2017 09:36:38 GMT

Anyone got any other ideas how I can prevent the script from wrapping?

Re: Wrap Text in Script Editor

kamal_sanguri — Fri, 07 Jul 2017 10:23:15 GMT

On this screen (which will pop up) once you done with connection and click on select.

Select the Column, By default Row would be selected.

Re: Wrap Text in Script Editor

kamal_sanguri — Fri, 07 Jul 2017 10:25:25 GMT

you will see this screen when you click on select. After making connection by clicking on Connect

Re: Wrap Text in Script Editor

shane_spencer — Fri, 07 Jul 2017 10:38:16 GMT

I'm loading Data from Files and Table Files...

I have gone in to Select and changed to Column but it's had no effect on the wrapping of the fields when I load a spreadsheet for example.

Re: Wrap Text in Script Editor

edmondo_tassi — Wed, 30 Aug 2017 14:10:30 GMT

Excuse me, is an italian version.

The concept is the same I think is the same. Left the max lenght of a line code to 1 and you have the behaviour requested. Reset to a Greater value if you want more fields in one line of codes, of course.

best regards

Re: Wrap Text in Script Editor

shane_spencer — Fri, 01 Sep 2017 08:48:02 GMT

Thanx! That's been bugging me for 2 months now!