topic Re: Difference in how load script is formated in scrip editor in QlikView

Difference in how load script is formated in script editor

marko_rakar — Fri, 09 Jun 2017 15:09:29 GMT

hello

In the past, when I tried to import new table and used "table files" function, I would end up getting neatly listed fields in my scrip editor, something like this:

Directory;

LOAD @1,

@2,

@3,

@4,

@5,

@6,

@7,

@8,

@9,

@10

Each field would get new row.

But now (I guess from version 12) I get following:

Directory;

LOAD @1, @2, @3, @4, @5, @6, @7, @8, @9, @10

How can I revert this so I get old format (old format is much nicer, I get full overview, it is easy to comment of one of the fields)?
The way it is done now is hardly readable and quite messy to intervene into the load script.

p.s. there is a chance I have messed up some preference but I can not find which one

Re: Difference in how load script is formated in scrip editor

el_aprendiz111 — Fri, 09 Jun 2017 20:56:53 GMT

Hi Marko

Re: Difference in how load script is formated in scrip editor

Peter_Cammaert — Fri, 09 Jun 2017 21:10:47 GMT

In the last tab of the Table Import wizard, set the value of Max Line Length to 1. That will force the script editor to place each field on a new line.

Best,

Peter

Re: Difference in how load script is formated in scrip editor

marko_rakar — Fri, 09 Jun 2017 21:25:44 GMT

thanks a lot, it seems that this default changed as some point

(it really gave me a headache why this happens)