on 04-28-2009 12:48 AM
One of our fields in our Main Table is a type of 'Lookup (Taxonomy)'.
The field is numeric and has values greater than or equal to a 1000. When it displays on the main table, it is inserting a comma (ex. 1,000)
Our process chain is failing in XI. It is giving us the following error "argument '11,991' cannot be interpreted as a number'.
Is there anyway to change the format on the Main table to not insert a comma? Or any way that we can format the value so it syndicates a value without a comma
Thanks
Chris
Hi Chris,
If you have maintained your data type as integer and not text, then apart from using normalization, you can also use numeric 1000 separator.
In the syndicator go to map properties -> Numeric 1000 separator -> select None.
Hope it helps.
Thanks,
Minaz
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chris,
Ill just like to add to what Minaz has said,You can make the format changes for your master data at the syndiactor stage as well.
The only difference while doing so at the data manager level and the syndiactor level is that,If you want to mainatin your data as in your case without a 1000 separator throughout you just need to make the change in the MDM Data manager,but at time you may need to maintain the data in one consistent format in MDM but while sending it to different target system you may need to change the format only while syndicating.
There for you have these option in the syndicator as well.
Besides Normalizing your master data as mentioned in the above post you can also perform the 1000; separator change in the syndiactor >Map properties.
Hope It Helped
Thanks & Regards
Simona Pinto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chris,
In Syndicator, go to the tab Destination Items-> Normalization > Standard.
Standard Normalization removes the punctuations from the selected field.
Hope it helps.
Thanks,
Minaz
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chris,
You can use the MDM data manager Configuration options to make the configuration settings for the 1000 separator.
Numeric 1000s separator
Separator character for 000s in numeric fields:
· comma
· period
· none
· space
You canchange this to None if you do not want any separator ,by default its ,
Hope It Helped
Thanks & Regards
Simona Pinto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chris,
Yes you can avoid comma in MDM Data Manager. Go to Configuration -> Options and check the Format section, you will find the property Numeric 1000s Separator by default this property is set to comma you can set this to None to not to insert comma in numeric field.
Regards,
Jitesh Talreja
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.