Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
get_table_keys [2013/08/08 18:42] admin created |
get_table_keys [2013/08/08 18:48] (current) admin |
||
|---|---|---|---|
| Line 9: | Line 9: | ||
| ^ Name ^ Type ^ Description ^ | ^ Name ^ Type ^ Description ^ | ||
| | Table | [[Table Type|Table]] | The input table. | | | Table | [[Table Type|Table]] | The input table. | | ||
| - | | Keys | [[Table Type|Table]] | The table containing the keys from the input table first key column. | | ||
| ===== Outputs ===== | ===== Outputs ===== | ||
| Line 24: | Line 23: | ||
| The result table has columns "Key*" and "Value" and both columns contain the same values. The column types are the same types of the first key column from the input table. | The result table has columns "Key*" and "Value" and both columns contain the same values. The column types are the same types of the first key column from the input table. | ||
| - | Example: | + | **Example 1:** |
| + | |||
| + | Input: | ||
| ^ Key1* ^ Key2* ^ Value1 ^ Value2 ^ | ^ Key1* ^ Key2* ^ Value1 ^ Value2 ^ | ||
| - | | 1 | 2 | 2.2 | 3.1 | | + | |@lightgreen: 1 | 2 | 2.2 | 3.1 | |
| - | | 1 | 3 | 2.1 | 3.1 | | + | |@lightgreen: 1 | 3 | 2.1 | 3.1 | |
| - | | 1 | 6 | 1.2 | 4.2 | | + | |@lightgreen: 1 | 6 | 1.2 | 4.2 | |
| - | | 2 | 2 | 3.2 | 6.1 | | + | |@lightgreen: 2 | 2 | 3.2 | 6.1 | |
| - | yields | + | Result: |
| ^ Key* ^ Value ^ | ^ Key* ^ Value ^ | ||
| - | | 1 | 1 | | + | |@lightgreen: 1 |@lightgreen: 1 | |
| - | | 2 | 2 | | + | |@lightgreen: 2 |@lightgreen: 2 | |
| + | |||
| + | **Example 2:** | ||
| + | |||
| + | Input: | ||
| ^ Name* ^ Age* ^ Value1 ^ Value2 ^ | ^ Name* ^ Age* ^ Value1 ^ Value2 ^ | ||
| - | | "Hermann" | 28 | 2.2 | 3.1 | | + | |@lightgreen: "Hermann" | 28 | 2.2 | 3.1 | |
| - | | "Romulo" | 12 | 2.1 | 3.1 | | + | |@lightgreen: "Romulo" | 12 | 2.1 | 3.1 | |
| - | | "Bruno" | 61 | 1.2 | 4.2 | | + | |@lightgreen: "Bruno" | 61 | 1.2 | 4.2 | |
| - | | "Danilo" | 25 | 3.2 | 6.1 | | + | |@lightgreen: "Danilo" | 25 | 3.2 | 6.1 | |
| - | yields | + | Result: |
| ^ Key* ^ Value ^ | ^ Key* ^ Value ^ | ||
| - | | "Hermann" | "Hermann" | | + | |@lightgreen: "Hermann" |@lightgreen: "Hermann" | |
| - | | "Romulo" | "Romulo" | | + | |@lightgreen: "Romulo" |@lightgreen: "Romulo" | |
| - | | "Bruno" | "Bruno" | | + | |@lightgreen: "Bruno" |@lightgreen: "Bruno" | |
| - | | "Danilo" | "Danilo" | | + | |@lightgreen: "Danilo" |@lightgreen: "Danilo" | |
| ===== Internal Name ===== | ===== Internal Name ===== | ||
| GetTableKeys | GetTableKeys | ||
| - | |||