Overview
Returns true if specified key value exists in the dictionary.boolean myDataTableDictionary.Has(key: string)
Arguments
string key
Key of value to check
Returns
True if key value exists in the dictionary, returns true, otherwise returns false.Remarks
If key value trimmed if starts with numeric 0 characters if not contain any '.' (dot) character. For example : '00001234' key becomes '1234' but '000.1234' preserved.
The following code returns value 'true' for variable name_to_check if name "John Doe" exists in the dictionary:
Example
| Code Block | ||
|---|---|---|
| ||
var table = $Database.Get({
Parameters : {
TargetSchema : 'HR',
TargetTable : 'Persons'
}
});
var list = table.ToDictionary('Name');
var name_to_check = list.Has('John Doe'); |