on 08-30-2013 7:30 PM
Hi Experts,
I am importing Postal code information from excel.The issue I am facing is that preceding zeroes are getting truncated.
I have set the format of column as text but still those value are not being picked up correctly in MDM. Please help.
Thanks
Shambhu
Hi Shambhu,
This is an excel error and correction at source is necessary before importing.
Please do the following -
This will ignore all the errors in the selection you have. But you must start with the first error to get the pop-up to ignore them.
After this connect the source with Import manager and observe the count of entries for Postal Code;this should be same as in Excel.Post this you can import and validate data.
Thanks,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.