How to save what I coded in the data load editor as a qvd file?

[Nemo1]

this may be a stupid question, but I concatenated some data in my data load editor and I wanna use this to concatenate it with another qvd file..

how can i save what i coded as a qvd file? so i could concanenated with more data?

tjhanks!!

[Nemo1]

Hello Anil, 

thanks for your answer 🙂

The script that I want to save looks basically like this:

Daten:

Load

A1

A2

A3

A4

........

FROM [lib://***********************************/Vacation_2017.qvd]
(qvd);

Concatenate (Daten)

Daten_2018

Load

A1

A2

A3

A4

........

FROM [lib://***********************************/Vacation_2018.qvd]
(qvd);

The script I can run it with no problems... It loads! 

I just cannot save it

greetings

[Antoine04]

If you want to save this as qvd, then you need to write :

Store Daten into 'lib://DataFiles/Daten.qvd'(qvd);

Because the name of the table you want to save is "Daten"

[Nemo1]

Hello Antoine,

it looks like this:

The script that I want to save looks basically like this:

Daten:

Load

A1

A2

A3

A4

........

FROM [lib://***********************************/Vacation_2017.qvd]
(qvd);

Concatenate (Daten)

Daten_2018

Load

A1

A2

A3

A4

........

FROM [lib://***********************************/Vacation_2018.qvd]
(qvd);

The script I can run it with no problems... It loads! 

I just cannot save it

greetings

[Anil_Babu_Samineni]

@Nemo1 How is your model looks like? And is both tables visible in your model this case? "Daten" and "Daten_2018"?

[Antoine04 · Accepted solution]

Is "Daten" the table you want to store ?

If yes then : 

Store Daten into 'lib://DataFiles/Daten.qvd'(qvd);

Because the name of the table you want to save is "Daten"

[Nemo1]

You are my hero, thanks! it did work! 😄 😄 😄 😄 😄 

[RamanaKumarChintalapati]

Hi @Nemo1 ,

Please follow below script for Saving file into QVD:

//QVD File making

LOAD
CurrencyKey,
CurrencyAlternateKey,
CurrencyName
FROM [lib://QVD File Making:DataFiles/Currency.xlsx]
(ooxml, embedded labels, table is Currency);

Store Currency into [lib://QVD File Making:DataFiles/Currency.qvd];

Hope it Helps you!!!

Thanks!!

[Antoine04]

You're welcome ! 

Do not hesitate for more questions 🙂

Regards,

Antoine