Table transformer - split values in different situations

[Matias G Labrana]

Good day community,

I would like to know how to split values in table transformer as it shows in the table below:

COLUMN A	COLUMN B
Value A	A, B, C
Value B	A/B/C
Value C	A-B-C
Value D	·         A ·         B ·         C

In the 4 cases presented, basically I want this values by separate.

Regards!

[Stiltsoft support]

Hi @Matias G Labrana ,

We can suggest the following workaround for your case:

In the internal Table Transformer macro we replace different symbols by the same symbol (for example, by commas as you have them in the first cell):

SELECT *,
REPLACE('COLUMN B', "/", ", ") AS 'COLUMN B'
FROM
(SELECT *,
REPLACE('COLUMN B', "-", ", ") AS 'COLUMN B'
FROM T*)

Now in the external Table Transformer macro we can split our array:

SEARCH / AS @a EX('COLUMN B'->split(",")) /
RETURN(@a->'COLUMN A' AS 'COLUMN A', _ AS 'COLUMN B') FROM T1

What concerns the "Value D" row, it seems that here you use bullet points or smth similar. The Table Transformer macro works only with visible separators.