cancel
Showing results for 
Search instead for 
Did you mean: 

How to Default a constant value while inserting new record

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hey,

You can follow the approach given in below thread:

Thanks

Aamir