I’m wanting to add some list items I generate based on a formula into a dimension list automatically.
The Item function allows us to search and return a dimension if it exist in a list but I’m wondering how instead of returning BLANK I would be able to automatically add a missing item into the dimension.
Some context: Pulling data from multiple sources which may have the same Primary Key therefore in Pigment I would like to Concatenate the Data Source Name to the ID and add it into a Global dimension we maintain.
Ex.
Global Dimension is IDs
Data Source 1 IDs
- 1
- 2
- 3
- 4
Data Source 2 IDs
- 2
- 4
Processing I would like to do in pigment is to add Data Source 1 and 2 IDs to the global dimension so the output would be:
- DS1-1
- DS1-2
- DS1-3
- DS1-4
- DS2-2
- DS2-4
