Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am new to QV. I want to take some information from QlikView and then export it and use in another DataBase. Like paste that field outside QV.
How can I do that?
Thank you very much.
But if I don't want to create a new document, just insert the data in the other DataBase... or is always necesary to have this excel file in orther to link the variables?
Unfortunately there is no way to write directly to a database with QV. If you want to get data out of QV and into a database then you will have to export to a file and import it using a different tool.
For example, I often want my data in SQL Server so I build a formatted straight table and export it to excel. Then I use SSIS or the SQL Importer to pull the data into a SQL table.
You can right click the object containing the information you want and export it to excel.
The most straight-forward option is to export it to excel and then use that as the data source. I would suggest creating a straight table report that formats the columns in a way that would match the import.
You could also store the data in a QVD and use that as a data source. This would be a good option if it's something that you would want to do on a schedule.
Unfortunately there is no way to write directly to a database with QV. If you want to get data out of QV and into a database then you will have to export to a file and import it using a different tool.
For example, I often want my data in SQL Server so I build a formatted straight table and export it to excel. Then I use SSIS or the SQL Importer to pull the data into a SQL table.
You can develop a vbscript to write back to a database. Have you consider this approach?