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 | ||
- |