This article is suitable for a Process Mapper

Ref: 201205311540JH

Last Edited: May 31st 2012

Relates to: PN 11.2 and Onwards

Sometimes two different shapes can share the same Property, say TotalCost. However, on one shape this is stored as a Number, and on another shape it is stored as a String (text). When Exporting to Excel, because the Property of both shapes is stored in the same column, there are inconsistent data types in the same column. This  causes difficulties when using Excel's data query functionality. 

The purpose of this feature therefore is to enable the user to specify the data type that is written. So, in the example just given, if the user requires the TotalCost field to always be written as say a Number, then when Exporting to Excel, Triaster will attempt to convert any non-Number data types to a Number. 

If the conversion is unsuccessful, defaults will be used for the intended data type (typically 0, empty string or false for a Boolean). Check out Tools > Options > Export to Excel to experiment with this setting.

For more information on Exporting to Excel, Click Here.

Need further help? Contact the Triaster Support team by e-mailing support@triaster.co.uk or by calling us on +44 (0)870 402 1234.

Do you have any feedback or suggestions that you would like to share with Triaster? We would love to hear from you! Please e-mail feedback@triaster.co.uk