Can table transformer also recognise numbers as text?

Alexandra Kühn_puzlnw

Is it possible to force the table transformer to recognise numbers as text/string instead of numbers?

In my example I have a list of seven-digit numbers separated by semicolon or comma or space. Now I'm trying to split by either separator which does not work for comma or space separated numbers and for none of these, if my list only contains of one single number. Using strings everything works fine.

Thanks and regards

 

Alex

Stiltsoft support

Hi @Alexandra Kühn ,

Seems that you are referring to this case related to the Table Transformer macro and arrays: https://community.atlassian.com/t5/Confluence-questions/Flatten-an-array-in-Table-transformer-macro/qaq-p/2048472

For this (or similar) examples you may just modify the query and transform your numbers to text:

SEARCH / AS @a EX(TEXT('Col 2')->split(",")) /
RETURN(@a->'Col 1' AS 'Col 1', _ AS 'Col 2') FROM T1