Skip to main content
10-Marble
February 24, 2023
Solved

Export edited grid column along with all data from grid

  • February 24, 2023
  • 1 reply
  • 1423 views

Hi Developers,

 

I have a requirement to take 3 different data sources (1 label and 2 grids) and export an excel from it.

I am not able to get csv with edited column along with its other original entire grid columns.

Please provide service to achieve this, if someone has any.

 

 

 

Best answer by Sathishkumar_C

Yes, it's possible.

 

1. Create a datashape with all required fields

2. Read all the data from infotable

3. Insert into new info table with new data shape.

1 reply

17-Peridot
February 24, 2023

write a custom server.

  • inputs [3]
  • compile all the 3 input data into single infotable
  • output as infotable with data export widget or Write CSV data into repository
10-Marble
February 27, 2023

Hi @Sathishkumar_C ,

I referred to solution available on  https://www.ptc.com/en/support/article/CS237109.

I took the code and used AddRow snippet, but I want to merge data of both infotable in one row.

Is it possible?

17-Peridot
February 27, 2023

Yes, it's possible.

 

1. Create a datashape with all required fields

2. Read all the data from infotable

3. Insert into new info table with new data shape.