Can table transformer also recognise numbers as text?

Alexandra Kühn
Contributor
June 10, 2024

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

1 answer

1 accepted

2 votes
Answer accepted
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 10, 2024

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

Alexandra Kühn
Contributor
June 13, 2024

Thanks :) 

That worked 

Like Stiltsoft support likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events