Exporting two infotables using DataExport widget.

[TIRUNL]

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.

[PaiChung · Accepted solution]

DataExport widget will export exactly what the service puts out.

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

[TIRUNL]

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

[PaiChung]

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.

[TIRUNL]

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

[TIRUNL]

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