topic Re: Getting a junk line after load in QlikView in QlikView

Getting a junk line after load in QlikView

Truist_np — Mon, 01 Mar 2021 19:02:38 GMT

Hello Team,

I am having weird issue. While I am loading a QVD I am having below load. There are 89 QVD like this . I need to move it to prod.. But I am concerned to the [<?xml version="1.0" encoding="UTF-8" standalone="yes"?>], after load Statement.

Also while opening it is loading two times.

Re: Getting a junk line after load in QlikView

edwin — Mon, 01 Mar 2021 22:31:32 GMT

does it load properly when you delete that field in your load statement?

Re: Getting a junk line after load in QlikView

Truist_np — Mon, 01 Mar 2021 22:38:47 GMT

Hi,

Yes . It is loading properly with all data. And if one comments this line before loading , then no problem. But I am concerned why it is coming.

Re: Getting a junk line after load in QlikView

marcus_sommer — Tue, 02 Mar 2021 14:07:50 GMT

I think not this load is causing the issue else the previous creation of those qvd's is the reason. Maybe they weren't stored explicitly as qvd's like:

store table into table.qvd (qvd);

and the here marked (qvd) determination of the file-format is missing.

- Marcus

Re: Getting a junk line after load in QlikView

Truist_np — Tue, 02 Mar 2021 17:45:27 GMT

Hello Marcus,

Thank you! These are the scenario how the QVD are stored.

STORE Incremental into $(vQVDCategory1)$(vQVDName).qvd (qvd);
STORE TruncateLoad into $(vQVDCategory2)$(vQVDName).qvd (qvd);
Store TF10 into $(vQVDCategory1)TF10_$(vCurrentYear).qvd (qvd);

Also while loading from qvd we used
Incremental:
//Load Records from existing QVD
Load *
from [$(vQVDCategory1)$(vQVDName).qvd];

//from $(vQVDCategory1)$(vQVDName).qvd (qvd);we used the highlighted one instead the commented one . We put bracket for a reason. This process is used in all script. Please advice.

Re: Getting a junk line after load in QlikView

marcus_sommer — Wed, 03 Mar 2021 07:34:13 GMT

By loading and storing a file it's necessary to specify the file-format - it may look as if it's optional and there is often no error but the then applied default file-format may not be suitable to the requirements. Therefore go through all creation and loading steps (it may more as two within an ETL chain) and check if (qvd) is always set as file-format by loading/storings into qvd's.

To wrap the full-path into brackets is needed if there any spaces or special chars included which may especially by the use variables not always obviously - therefore use the best practice and apply it always.

- Marcus