How to export the Data Model to a excel sheet?

[#1]

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

[Chanty4u]

Hi,

I am Not sure.

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

HTH

Chanty

[#3]

Hi chanty,

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

Thanks

Anjaneyulu

[Anonymous]

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.

[lironbaram · Accepted solution]

hi

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 ',');

NEXT

[rido1421]

Hi Anjaneyulu

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

it seems to meet your requirement

[#7]

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