Login
Introduction Version

Table row concat

TASK
Typing name :  TASK.gws_core.TableRowConcat Brick :  gws_core v

Concatenate two tables along the rows by merging columns

Concatenate two tables along the rows by merging columns. The total number of rows will be the sum of the two tables. The total number of columns will depend if the two table have common columns (based on name).

If the two table have the same column (based on name), the values of theses columns are concatenated (starting from the first table) into the same column.

If a column doesn't exist in the other table, it will be concatenate with value provided in the Fill empty values with parameter.

Example

Let's say you have the following tables.

A B
A1 B1
A2 B2
A C
A3 C3
A4 C4

Here is the result of the row concatenation.

A B C
A1 B1 NaN
A2 B2 NaN
A3 NaN C3
A4 NaN C4

NaN value are create for the B and C columns because they don't exist in the other table. You can provide another value with the Fill empty values with parameter.

The first two rows will have the tags from the first table and the last two rows will have the tags from the second.

The column tags will depend on Column tags options parameter.

Parameters

Column tags options

This parameter allows you to define what to do with the column tags. Here is the different options:

  • ignore: the tags are ignored and left empty
  • keep first: only the tags of the first table are keept
  • merge from first table: tags of the first and second table are merged (the first table tags override the second table tags)

Input

First table
2d excel like table
Second table
2d excel like table

Output

Concatenated table
2d excel like table

Configuration

column_tags_options

Optional

What to do with the column tags. See doc for more info

Type : stringAllowed values : ignore  keep first  merge from first table  Default value : ignore

fill_nan

Optional

Fill empty value generated by the concat with this value

Type : stringAllowed values : NaN  Empty  0  Default value : NaN