Publication dateMar 9, 2022
Confidentiality public Public
Extract row tags to new column
TRANSFORMER
Typing name : TASK.gws_core.TableRowTagExtractor Brick : gws_core Extract row tags values to a new column
Transformer to extract values of tags into in new columns that are appended to the end of the table.
Multiple tag keys can be provided to extract multiple tags (one column is created by tag key).
Example
Let's say you have the following table, the column row_tags does not really exist in the table, it is just to show the tags of the rows.
| Row tags |
A |
B |
| Gender : M |
1 |
5 |
| Gender : F |
2 |
6 |
Here is the result of the extraction of the Gender tag.
| Row tags |
A |
B |
Gender |
| Gender : M |
1 |
5 |
M |
| Gender : F |
2 |
6 |
F |
The Gender column is created containing the values of the Gender tag.
login
Input
Table
2d excel like table
logout
Output
Table
2d excel like table
settings
Configuration
Type : ListMaximum occurrences number : -1Tag key to extract
Type : stringName of the new column that will contain the tag values. If empty, the tag key will be used
Type : string Technical bricks to reuse or customize Have you developed a brick?
Share it to accelerate projects for the entire community.