Publication dateMar 9, 2022
Confidentiality public Public
Extract column tags to new row
TRANSFORMER
Typing name : TASK.gws_core.TableColumnTagExtractor Brick : gws_core Extract column tags values to a new row
Transformer to extract values of tags into in new rows that are appended to the end of the table.
Multiple tag keys can be provided to extract multiple tags (one row is created by tag key).
Example
Let's say you have the following table, the first row does not really exist in the table, it is just to show the tags of the columns.
| Row name |
A |
B |
| Column tags |
Gender : M |
Gender : F |
| 0 |
1 |
5 |
| 1 |
2 |
6 |
Here is the result of the extraction of the Gender tag.
| Row name |
A |
B |
| Column tags |
Gender : M |
Gender : F |
| 0 |
1 |
5 |
| 1 |
2 |
6 |
| Gender |
M |
F |
A new row 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 row 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.
