Trying to Cast string as integer

Julio Torres_igixk6

Hi all,

 

I am using Table transformer on JIRA data (custom fields). I am trying to cast a field which is string data into an integer so I can use number equations on the data. I can't seem to do this, or at least I don't know how. In Table transformer I write 

 

Select t1.'XYZ field', CAST(T1.'XYZ field' AS INT) AS 'ABC field'

When I get to typing INT- nothing shows up in the drop down for available functions. Am I using the wrong syntax?  Is this available in Table Transformer? What can i do to rectify this issue?

Stiltsoft support

Hi @Julio Torres ,

If you are referring to the Table Transformer macro provided by the Table Filter, Charts & Spreadsheets for Confluence app, you may visit our support portal to get help.

Meanwhile, without the source table and the final goal, I'm afraid, we don't get the case.

If you have numbers (with or without decimal and thousands separators) in your source table, you can perform calculations with the help of the Table Transformer macro and Pivot Table macro without any additional steps.