Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mallikarjun_h
Partner - Creator
Partner - Creator

is it possible to append a already existing qvd with data extracing from SAP?

I have a qvd file.

I am extracting a table which has same structure as in already existing qvd file using SAP extractor connector.

In script first I am loading data from qvd file and after connection string concatenating the extracted data with this qvd but I am getting error.

Is there any way to append this extracted file directly to this qvd?

5 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

No, you cannot append to a QVD file on disk. Symbol table reasons.

The technique you currently use is a good one: LOAD APPEND STORE (overwrite). What error message are you getting?

mallikarjun_h
Partner - Creator
Partner - Creator
Author

I get the message saying  garbage after connection string

Peter_Cammaert
Partner - Champion III
Partner - Champion III

What does your CONNECT string look like? Is it properly terminated? What comes immediately after the CONNECT statement?

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

That usually means a missing semi-colon ; as a terminator for the connection string.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
mallikarjun_h
Partner - Creator
Partner - Creator
Author

Hi

Thanks. As you said semi-colon is missed. And it worked I can append the data and store the result in qvd file with same name as the previous one. It worked thanks...