Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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...