UNSPSC Hierarchy Load

[Former Member]

Hi ,

I want to load the complete UNSPSC hierarchy into one of the hierarchy table ( target ) . The source data file looks like :

Segment title->Segment Code->Class Title->Class Code->Family Title->Family Code->Commodity Title->Commodity Code .

Example

10000000 Live Plant and Animal Material and Accessories and Supplies 10100000 Live animals 10101500 Livestock 10101501 Cats

10000000 Live Plant and Animal Material and Accessories and Supplies 10100000 Live animals 10101500 Livestock 10101502 Dogs

10000000 Live Plant and Animal Material and Accessories and Supplies 10100000 Live animals 10101500 Livestock 10101504 Mink

10000000 Live Plant and Animal Material and Accessories and Supplies 10100000 Live animals 10101500 Livestock 10101505 Rats

Target hiearchy table looks like :

UNSPSC name , UNSPSC Code .

I am partitioning the source field by all the titles and mapping it to UNPSSC name , Similalrly i am partitioning all the code fields and then map to UNSPSC Code . the problem is I am not able do the value map the Code fields in the source & UNSPSC Code field in the target . The target comes hidden in the value map table .

The load works perfectly fine with just the name . Pls suggest the resolution . thanks

[Former Member]

Hello Amit,

You can try making the target code and name fields as display field=Yes. Evenmore, If this is a non production system you can change it, so the only display field is the code; this may be helpful in case you want to use automaping.

I hope this helps.