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.
Page 1 / 1
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.