on 08-22-2007 1:21 PM
Hi,
Appreciate if I can get some help in addressing following issue in Import manger MDM 5.5 sp4.
1. Trying to load hierarchy table with 3 distinct columns in the input file by selecting them and thru create hirarchy>by child>updating the parent , child and node information in the pop up box. However it is saying duplicate in column-2.
Input files format is
Manuf Category Sub-cat
-
-
-
3m Abbrasive Nylon
3m Abrasive Roll-G
3m Abrasive Poly
Card-G Abrasive Roll
Card-G Abrasive Synthetic
2. Not able to load data in actual sequence in Qual table , it is coming in random way even after introducing a sequence num with auto-id.It's header data should come as the first line but in data manager it is showing in alphabatic shorted way
Input data
PONO Text
-
-
1001 Header data
1001 Size-11111
1001 Weight-xx
1001 Packg-yy
1005 Header Data
1005 size
1005 weight
Appreciate any suggestion or tips please.
Thanks in advance, reo
Hi Reo
for the second opyion you want data like Header Size Weight so on as coloums heading. you can go to import manager select the table having this data in source.
now right click and create pivot table. take that field as key which have same values for all columna. and ok.
it will solve your second issue. but give some more information on 1st its not very clear.
Regards
Alok Sharma
please rewads if found problem solved.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alok,
Thanks for your response.
However for pivot we need a uniform trend of metadata value so that those metadata values can be converted to field. In my case 80% metadata value matches but 20% metadata values are discrete or varying.
Regarding 1st issue let me try to make it more clear .
Can you walk thru the steps to import a flat data consists of 3 column in source to a hierarchy table in destination. Complete steps of creating a hieracy table to importing is appreciated.
I have created a table type hierarchy and then tried to load the data from the source table having following data value . It gives an error like "duplicate data in column-2". My source data look like given below
Manufacturer Column-2 Column-3
-
-
-
3M Abrasive Nylon
3M Abrasive Roll
3M Abarasive Polymer
Carb-M Abrasive Roll-G
Carb-M Abrasive Synthetic
Thanks again, reo
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.