When we are importing data into a transaction list, and the data contains new dimension list items those are automatically added to the corresponding dimension list. However the new item is only added with the unique ID, and all properties (Name) are blank. Is there a way to get the dimension list name property (text) updated (even for already existing items), similar to when a csv-file is manually imported to a dimension list? Would be really nice to get an answer on this.
Solved
Update a dimension list text property from a transaction list
- Apprentice Author
Best answer by Stef
Hi Magnus,
You can use the BY LASTNONBLANK to get any text fields from your transaction list into another text formatted property of a dimension.
+13- Employee
- Answer
Hi Magnus,
You can use the BY LASTNONBLANK to get any text fields from your transaction list into another text formatted property of a dimension.
Log into the Pigment Community
No account yet? Create an account
Single Sign-On Need help?
Log in with your Pigment accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.