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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.