Login
Introduction
Technical Documentation
Tasks
Version

Table row tag extractor

TRANSFORMER
Typing name :  TASK.gws_core.TableRowTagExtractor Brick :  gws_core v Parent : 

Extract row tags values in 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
Gender : F 3 7
Gender : M 4 8

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
Gender : F 3 7 F
Gender : M 4 8 M

The Gender column is created containing the values of the Gender tag.

Parameters

  • The New column name parameter allows you to define the names newly create columns that contains tags
  • The ```Tag values type```` parameters allows you to force the convertion of the tag values.
    • Use numeric to convert the tag values to float.
    • User char to keep the tag values as strings.

Input

Table
2d excel like table

Output

Table
2d excel like table

Configuration

params

Type : ListMaximum occurrences number : -1

tag_key

Tag key to extract

Type : string

new_column_name

Optional

Name of the new column that will contain the tag values. If empty, the tag key will be used

Type : string

tag_type

Force tag values type, leave to char for no conversion

Type : stringAllowed values : char  numeric