Skip to main content
Workday User Guide
Last Updated: 2023-06-23
CREATE_MULTI_INSTANCE

CREATE_MULTI_INSTANCE

Description

CREATE_MULTI_INSTANCE
is a row function that constructs a Multi-Instance field from one or more provided Multi-Instance or Instance fields.

Syntax

CREATE_MULTI_INSTANCE
(
field_name
[,
field_name
])

Return Value

Returns one value per row of type Multi-Instance.

Input Parameters

field_name
Required. A field of type Multi-Instance or Instance. All instance values must use the same business object.

Examples

Create a Multi-Instance field out of multiple Instance fields:
CREATE_MULTI_INSTANCE([Journal1], [Journal2], [Journal3])
Create a Multi-Instance field out of instance values:
CREATE_MULTI_INSTANCE( CAST("070b0d082eee44e1928c808cc739b35f" AS Instance(eecb565181284b6a8ae8b45dc3ed1451)), CAST("f4c49debb3dc483baa8707dfe683503c" AS Instance(eecb565181284b6a8ae8b45dc3ed1451)) )