Export Field/Cell as a SQL Script

Thu, 02 Feb 2012 15:55:54 GMT

I am building a dashboard to capture error reports/QA testing, and there is a field in the data that will generate a SQL Select script that points to the problem areas in the data.

For example, if a job is run and 40 fields cause the job to fail, it'll populate a field in an audit table (that QV pulls from) with a SQL script that would select the 40 fields in the DW.

Would it be possible to download that script as a .sql file on a button press? Right now I have it as part of a pivot table, and I understand that I could just copy the cell's contents, but I was wondering if there was an easier way to do it.

Export Field/Cell as a SQL Script

stephencredmond — Thu, 02 Feb 2012 17:37:05 GMT

Hi,

Add a button and add an Action.

Look at the External / Export option - you can choose to export a single field or multiple fields. Either to clipboard or a file.

Regards,

Stephen

topic Export Field/Cell as a SQL Script in QlikView

Export Field/Cell as a SQL Script

Export Field/Cell as a SQL Script