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: 
paulyeo11
Master
Master

how to send SQL database file to other for test my script

Hi All

I am.learning about how to use QV for read SQL data file. And when I encounter some issue . I need other to reload my SQL database file . May I know how to do it ?

For text file I can just file attachment with QV QVW file.

Paul

4 Replies
datanibbler
Champion
Champion

Hi,

once you have read the data file, you can store it as a qvd file using the STORE command and you can just send your qvd_file as an email attachment.

If you have trouble with the original data file, that's a bit different, it would depend on what kind of database you have - the other person doesn't have access to your database, then?

Best regards,

DataNibbler

paulyeo11
Master
Master
Author

Hi Sir

I am using SQL Server 2008 R2

My SQL raw data file have a filed name which is REJECT _ CODE which only have number.

I need to add load script with ApplyMap for recode them to description.

If I save the file as QVD does it work as SQL ?

Paul

Sent from Samsung Mobile

datanibbler
Champion
Champion

Hi,

no, qvd is a QlikView-internal file format, nothing to do with SQL.

=> if you have trouble with the SQL_SELECT itself, that is another matter, you would have to somehow make that original data_file available to your tester - or give him access to the database.

What is your issue in particular? Maybe someone here can help.

And what is your issue with ApplyMap?

paulyeo11
Master
Master
Author

Hi Sir

SQL ApplyMap for Rejected Code display missing value

Above is the link which i encounter issue.

Paul