Skip to Content
1
Sep 08, 2023 at 10:14 AM

Concatenation in SAC data actions

185 Views

We have the need to concatenate two dimension IDs in a data action to form a new ID for another dimension. One of the original IDs is populated from an attribute of another dimension and does not come in with the data so we cant do this at the time of modelling.

e.g.

Plant: 1

Product: A (gets populated by a previous data action)

Plant\Product: 1A (or 1-A if we can use a delimiter)

Can this be done? if not, when will it be added?

Ed