on 07-19-2010 11:37 PM
I am performing mass import of data to Main Table. I have few fields in which I have to populate a constant value for all record while loading data. For Ex: Item Type = 'N' . This is constant value that remains same for all records. But this value is not available in the source file/structue.
Hi ,
You can achieve this requirement by adding new fields in source hierarchy in importmanager.
1. open import manager
2. select your source file in source hierarchy
3.Select any field and right click and select "Add new field"
4.it will add a new field with null value.
5.After mapping it to the destination field to which u can set constant values.
6. in the value mapping section ,set the constant value that you want to set in converted value coloumn.
7.import the file you will find this consyant values in mapped field.
if there are many field in which u want to set this value then right cick on new field that you just added and select add clone field and map this field to another field.
In this way you can achieve yr requirement.
Please inform us if u need more help.
Thanks,
Sudhanshu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sudha
As suggested by others this can be done by creating a new field in the source side as part of the import map itself. Map the Null value in the newly created field with value N in destination side or apply value convertor.
best regards-Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.