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!
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.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.