Discussions
Categories
- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 534.1K On-Premises Infrastructure
- 137.6K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Data Management - PBCS - Expression Issue
Hi experts,
This is for a dimension build using Data Management in PBCS not a data load.
We are concatenating two fields in an Import Format to get the Item Number and Description to be used as the Alias.
Item Number: 12345
Description: Cheescake 12pc 24OZ
Desired Outuput: 12345 - Cheescake 12pc 24OZ
Here's the Import Format. We are trying to put all kinds of Expressions where the green box is:
However when we run the Imoport in the Workbench the best we can get is the '-' without the leading and trailing space. So we have tried so many different combinations of things not sure this is possible or if there is a workaround.
Any ideas would be greatly appreciated as we are kind of new to the tool and realize this is not the full FDMEE version.
Best Answer
-
You could add a SQL mapping to concatenate the member and alias
In my example alias is assigned to the ICP column.
Cheers
John
Answers
-
You could add a SQL mapping to concatenate the member and alias
In my example alias is assigned to the ICP column.
Cheers
John
-
Yes that works too. I was just trying a new method in the Import Format as I thought that could be a powerful option in future. I just thought there had to be an expression to use .
Thanks as always!!!