cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Exporting two infotables using DataExport widget.

SOLVED
Highlighted
Level 7

Exporting two infotables using DataExport widget.

Hi All,

I have a requirement to Export data to CSV but need two sections in imported file. 

Is there a way to achieve this using DataExport Widget? Attaching screen shot for reference.

 

Appreciate anyone's help in advance.

 

 

Best Regards,

Lakshmi.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Exporting two infotables using DataExport widget.

DataExport widget will export exactly what the service puts out.

So I would create a service that combines the two tables.

5 REPLIES 5

Re: Exporting two infotables using DataExport widget.

DataExport widget will export exactly what the service puts out.

So I would create a service that combines the two tables.

Re: Exporting two infotables using DataExport widget.

I tried giving infotable of infotable can we do it in any other way?

Re: Exporting two infotables using DataExport widget.

Since you need the repeated header row, I don't think the infotable functions will help but I would just go with

var table1 = <MyFirstTable>

for each (var row in <MySecondTable>.rows) {

   table1.AddRow(row)

 

}

 

This may not quite work right, because you are adding a row to a table vs. a row object, so you may need  to find the proper syntax.

Re: Exporting two infotables using DataExport widget.

Thanks, will get back to you once I try this.

Re: Exporting two infotables using DataExport widget.

Thank you for your support, I am able to achieve with code provided with slight modification.