Skip to main content

TableDefineFromDictionary

The TableDefineFromDictionary function is only supported in Studio. It returns a new Table object inherited from the conversion of the dictionary. The Table will contain two columns one for the keys and the second for the values.

Prototype

    TableDefineFromDictionary(Dictionary; TableName; KeyColumnName; ValueColumnName)

Arguments

    Dictionary          Dictionary           By value  

The dictionary to be converted into a table.

TableName String/Variable By value

A valid string containing the table name.

KeyColumnName String By value

A valid string containing the name of the column that will contain the keys.

ValueColumnName String By value

A valid string containing the name of the column that will contain the values.

Returns

    Table

A new Table object containing the dictionary values.

Exception

    Undefined

Undefined is returned if:

- Dictionary is empty, or Undefined or not a valid Dictionary
- Name is empty, or Undefined or not a valid String

Example 

  $myNewTable = TableDefineFromDictionary($$myDictionary ; 'NewTable' ; 'Key' ; 'Value' )

This will return a new SFHub Table with the name NewTable, with two columns containing dictionary values.