Introduction Actions task Base env shell Base env shell task Conda env live task Conda env shell Conda env task Converter Create a sugar type of food Create report Create robot Dataset exporter Dataset importer Dispatch2 Download resource from a S3 bucket Download resource from external source Eat task Encoded table exporter Encoded table importer EncodingTable exporter EncodingTable importer Env live task Fifo2 Fly task Fs node extractor JSON Dict exporter JSON Dict importer Mamba env live task Mamba env task MetadataTable exporter MetadataTable importer Move robot Pip env live task Pip env shell Pip env task Python live task R conda env live task R mamba env live task Resource exporter Resource importer Resource picker Resource set exporter Resource stacker Robot add Select report Shell Shell task Shell wait Sink Smart interactive plot generator Smart json transformer Smart plot generator Smart table transformer Source Switch2 Table aggregator Table aggregator filter Table annotator Table column aggregator Table column aggregator filter Table column annotator Table column concat Table column data numeric filter Table column data text filter Table column operation mass Table column operations Table column scaler Table column tag aggregator Table column tag extractor Table column tag unfolder Table column tags deleter Table column tags selector Table columns deleter Table columns selector Table decoder Table encoder Table exporter Table filter Table filter Table importer Table replace Table row aggregator Table row aggregator filter Table row annotator Table row concat Table row data numeric filter Table row data text filter Table row scaler Table row tag aggregator Table row tag extractor Table row tag unfolder Table row tags deleter Table row tags selector Table rows deleter Table rows selector Table scaler Table to dataset converter Table transposer Task Text exporter Text importer The travel of `Astro` Transformer Uncompress file Upload resource to S3 Viewer Wait Wait task Write to file
Technical Documentation
Resources
Tasks
Protocols
Table column tag extractor
Extract column tags values in 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.
| A | B |
|---|---|
| Gender : M | Gender : F |
| 1 | 5 |
| 2 | 6 |
| 3 | 7 |
| 4 | 8 |
Here is the result of the extraction of the Gender tag.
| A | B |
|---|---|
| Gender : M | Gender : F |
| 1 | 5 |
| 2 | 6 |
| 3 | 7 |
| 4 | 8 |
| M | F |
A new row is created containing the values of the Gender tag.
Parameters
- The
New row nameparameter allows you to define the names newly create rows that contains tags - The ```Tag values type```` parameters allows you to force the convertion of the tag values.
- Use
numericto convert the tag values to float. - User
charto keep the tag values as strings.
- Use
Input
Table
2d excel like table
Output
Table
2d excel like table
Configuration
params
List-1tag_key
Tag key to extract
stringnew_row_name
Name of the new row that will contain the tag values. If empty, the tag key will be used
stringtag_type
Force tag values type, leave to char for no conversion
stringchar numeric