cancel
Showing results for 
Search instead for 
Did you mean: 

copy Field values

former_member283645
Participant
0 Kudos

Hello Experts,

As both caluculated option and assignment option are 'Table specific', is it possible to copy one field value to other field which is in a different table???

Please share your views in this context.

Thanks and Regards

Eva

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Eva,

You can copy only display field value of one table to another table field through assignment.

please try at yr end by opening table in which you assigned values as current table and create an assignment for particular field and select the value of other table in lookup value selection dropdown.

Hope it help you getting yr solution.

For more help please inform us.

Thanks,

Sudhanshu

former_member283645
Participant
0 Kudos

Hi,

i created a expression like ' IF(IS_NULL(copyfield),countryname.name)'

copyfield - > field in main table

countryname-> lookup field in main table

name -> DF in subtable (has only one record)

assignment is executing succesfully but i dont see any data in copyfield.

Kind Regards

Eva

Former Member
0 Kudos

Hi eva,

What is the type of copy field and name field.

Plz check record on which you run the assigment having data in name field or not.

Thanks,

Sudhanshu

Edited by: Sudhanshu Agarwal on Aug 2, 2010 6:49 PM

former_member283645
Participant
0 Kudos

name field and copyfield are of type text.

nodata is updated on the copyfield were i run this assignment.

Former Member
0 Kudos

Hi Eva,

This same assignment run fine at my end.

Please check that whether record on which you are running assignemnt contain data in countryname field or not.

Thanks,

Sudhanshu

Edited by: Sudhanshu Agarwal on Aug 2, 2010 7:45 PM

Former Member
0 Kudos

Hi Eva,

Your assignment is perfectly fine, IF(IS_NULL(copyfield),countryname.name)

assignment is executing succesfully but i dont see any data in copyfield.

See, you will not able to see record if the record on which you are executing Assignment does not have value filled for main table lookup field countryname.

I understand as you said that subtable has 1 record but nevertheless that subtable record is not associated with main table record field countryname, you will not get value through this assignment. Since if this value of maintable lookup field countryname is null, So on executing this assignment for this main table record for field copyfield it will populate blank.

So make sure that if you are going to run assignment on main table record then for that main table record countryname lookup field value is not null. I mean if this Countryname lookup field has value IND then on executing assignment your field copyfield will get populated with IND.

Kindly revert with result.

Regards,

Mandeep Saini

former_member283645
Participant
0 Kudos

i tested successfully.

So to conclude, if you wish to copy a field value cross table then there are 2 options.

Firstly if the source is DF then we need to go for assignment option.

IF the source is non-DF then we can use caluculated option at field level.

I tested both successfully.

Thanks guys.

Kind Regards

Eva

Answers (0)