on 06-18-2008 5:47 PM
Hello -
I am trying to create a field in the main table that will be created as a concatenation of all the values of the attributes of the taxonomy.
Is that a possibility?
If so - is there any reference documentation that could help me with that?
Please let me know
Thank you
Nadine
Hello -
what I am trying to do is create a field that will include a short descritption of the material using the taxonomy attributes.
the description would need to include a concatenation of the parent node, the child node and the list of attribute values that have been assigned to the material.
I believe this is a calculated field but I am trying to see what kind of calculation would be required.
Please let me know
Thanks
Nadine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nadine
use assignment expression for concatenating the attributes on the field you have created.
CONCAT(Attr1, Attr2). but you will get delimited text with ; as delimiter.
regards-
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Is it possible to use an undescore as the delimiter?
Not i guess. Concatenate is standard function offered by MDM with ; as delimiter. You can try with custom Java APIs for achieving this.
Also - how will the attribute be concatenated? How many characters of each field will be taken into account?
full text will be concatenated. Just check the Max length of the field you have created.
Award points if useful
BR-
Ravi
Hi,
If you want "_" as the delimiter you can use this expression
(attribute1 & '_' & attribute2)
you can append as many attributes you want just by appending "&".
It will just take the value from the field and not the field length i.e. if you are concatenating 2 attributes of type text of say length 50 each then after concatenation you can put the attribute values into field length of 50.
Regards,
Jitesh Talreja
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.