cancel
Showing results for 
Search instead for 
Did you mean: 

Import manager

Former Member
0 Kudos

Hi I am doing a import of a hierarchy file.

I have partioned com codes and descriptions seperately in a hierarchy structure.

I have mapped comcode<partition> to com_code

desc<partition> to description

1. my question is in the matching step ....... I am only able to see the comm code but I want to have a combination of commcode and desc.

why is my match records tab showing only the comcode, why is it not showing all the mapped fields.

how can I add other other mapped fields.

2. and what is the use ADD button at field mapping level ..... example pls

regards,

ve

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

whats the data type/cardinality of ur desc field ??

thanks

-Adrivit

Former Member
0 Kudos

Adrivit,

my data type is text.

rgds,

ve

Former Member
0 Kudos

If hierarchy table, must be the main display field that can be a matching field

check 7.1 mport manager reference guide page : 338

thanks

-Adrivit

Former Member
0 Kudos

Hi

We can not add Description field in matching as correctly mentioned. If this is what you want then define Description as main display field and also Unique key for the Hierarchy table.

Thanks-Ravi

Former Member
0 Kudos

Hello ve

1. my question is in the matching step ....... I am only able to see the comm code but I want to have a combination of commcode and desc.

why is my match records tab showing only the comcode, why is it not showing all the mapped fields.

how can I add other other mapped fields.

1a: your "desc" value should be unique

2. and what is the use ADD button at field mapping level ..... example pls

2a:

in source you have

h1

h11

h12

h13

in dest you have

h1

h11

h12

you can add h13 to dest when press "add"

Regards

Kanstantsin Chernichenka

Former Member
0 Kudos

Hi Kanstantsin,

few clarifications.

1. Desc should be unique - this is my hierarchy so my leaf node is always unique

example

<comm code> <desc>

01 TV

-02 - LCD

--03 - 40 inc

so I have partitioned the codes in a hierarchy and mapping it to my code field in destination

01

-02

--03

similarly I am doing for my desc.

2. Okay I add H13 to my destination, but I dont have H13 in my repository, so will it create any field on my repository.

if this is only a virtual field ..... what is the use of this.

pls help me understand.

rgds,

ve

Edited by: veena sexana on May 19, 2011 7:03 AM