Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
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"
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
@Nemo1 How is your model looks like? And is both tables visible in your model this case? "Daten" and "Daten_2018"?
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"
You are my hero, thanks! it did work! 😄 😄 😄 😄 😄
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!!
You're welcome !
Do not hesitate for more questions 🙂
Regards,
Antoine