topic Re: How to export the Data Model to a excel sheet? in QlikView

How to export the Data Model to a excel sheet?

Tue, 29 Nov 2016 12:14:44 GMT

Hi All,

I am having a requirement like ;

I have a data model ,from there i need to export each table data to a excel report.Each table may contain N number of fields.

Example: I have a data model like below:

I need to export Master Calednder,Products,etc.. Tables into excel data report.So kindly help me on this.

Thanks & Regards,

Anjaneyulu

Re: How to export the Data Model to a excel sheet?

Chanty4u — Tue, 29 Nov 2016 12:20:12 GMT

Hi,

I am Not sure.

Create a table box object in front end add your fields/Tables and send to excel.

HTH

Chanty

Re: How to export the Data Model to a excel sheet?

Tue, 29 Nov 2016 12:23:30 GMT

Hi chanty,

Ok ,,,I will try this and i will get back !

Thanks

Anjaneyulu

Re: How to export the Data Model to a excel sheet?

Anonymous — Tue, 29 Nov 2016 12:33:46 GMT

Hi..,

we can't export entire data model at the same time....but we can export each table data separately...

i hope this is helpful to you..

Create a..table box with the data you have in your table,

then send to excel.....each table separately.

Re: How to export the Data Model to a excel sheet?

lironbaram — Tue, 29 Nov 2016 12:39:44 GMT

this part of script

will export all the tables in the model into csv files

let vtables = NoOfTables();

for i=0 to $(vtables)-1

let vTable = TableName($(i));

store $(vTable) into $(vTable).csv (txt,delimiter is ',');

Re: How to export the Data Model to a excel sheet?

rido1421 — Tue, 29 Nov 2016 12:39:45 GMT

Hi Anjaneyulu

As Chanty 4U suggested create a system table and send that to excel.

it seems to meet your requirement

Re: How to export the Data Model to a excel sheet?

Thu, 01 Dec 2016 09:42:45 GMT

Hi Liron,

Thanks for your Information.It's more easiest approach than what Chanty4U provided for generating the excel data from a original qvw file.

Thanks alot once again.

Regards,

Anjaneyulu