Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X
Hi Developers,
I have a grid which I am exporting into a csv file via Data Export widget. I am using ThingWorx 8.5.
There is a column (OEE) which I have excluded in Grid Configuration and I am not showing it on the screen.
However, on exporting that grid data, it is coming in the excel file.
I need to remove OEE column, kindly suggest how to exclude it from excel.
Thanks in Advance.
Solved! Go to Solution.
The Grid shows data provided from an Infotable.
The Data export widget also takes the same Infotable data.
There is no connection between Grid-configuration and the DataExport widget. If you don't want to export a specific column, the column must not be in the infotable. Maybe you can use https://www.ptc.com/en/support/article/CS180324 to remove the column in the service providing the Infotable?
The Grid shows data provided from an Infotable.
The Data export widget also takes the same Infotable data.
There is no connection between Grid-configuration and the DataExport widget. If you don't want to export a specific column, the column must not be in the infotable. Maybe you can use https://www.ptc.com/en/support/article/CS180324 to remove the column in the service providing the Infotable?
Hello @VK_10159720 ,
Where are you getting the data from?
If it is an SQL query, it might be simplest to just write a new query, leaving out the columns you do not want.
I tried finding some snippet that could do this, but couldn't really find any, so @nmutter's way with removing the field for each row might be the best way
Regards,
Jens