topic Re: I want to change the Load Script Format.? in QlikView

I want to change the Load Script Format.?

Sat, 16 Sep 2017 20:40:24 GMT

Hi All,

I'm loaded a simple .csv file in QlikView 12.10.0, but it is loading all fields in a single line instead of multiple lines.@ Please see the below image...

When I'm trying to comment one particular filed, it is very difficult to do that.

I want to load the script in below format. Please help me where I'm missing.

Re: I want to change the Load Script Format.?

swuehl — Sat, 16 Sep 2017 20:50:28 GMT

Sorry, I don't understand.

What is preventing you from writing the script like shown in the second Image?

Besides that, you can use /* ..*/ to comment blocks of code (compared to // commenting rest of line).

Re: I want to change the Load Script Format.?

Sat, 16 Sep 2017 20:59:31 GMT

Hi Stefan,

Thanks for your quick response..

Even, I don't understand what is preventing me. I just simply loaded .csv , .xls and qvd but all the files loading like first image.

I want each and ever single field in my script is in different lines, not in single line.

Re: I want to change the Load Script Format.?

vishsaggi — Sun, 17 Sep 2017 01:44:45 GMT

Can you show some screen shots from the beginning like how you loading the file each step. Coz i tried loading .csv and .qvd and they are loading fine with individual columns. Can you share some screenshots to look into?

Re: I want to change the Load Script Format.?

Sun, 17 Sep 2017 04:36:11 GMT

Hi,

No need to worry because after the field name there is ',' separated so if you want those fields in separate lines please enter after ',' for each period and finally save and reload output will come exactly what we are expecting.

Hope this will help....

Re: I want to change the Load Script Format.?

Sun, 17 Sep 2017 05:44:19 GMT

Simply Clicking on the Table files option in EDIT Script and select the file from the folder location and then finish

Re: I want to change the Load Script Format.?

swuehl — Sun, 17 Sep 2017 08:58:58 GMT

I vaguely remember a similar issue reported here in the forum, but I can't find the thread and I don't remember the solution.

Any reason why you are using the initial release of QV 12.1 and not the current one (SR8, I think)?

If it's possible, could you test on a more recent version?

Re: I want to change the Load Script Format.?

antoniotiman — Sun, 17 Sep 2017 09:31:52 GMT

Maybe this will help You

Load Script text is not aligned

Regards,

Antonio