How to set same target fields with 2 different target table in field map

[Gautam Raj]

I get the below error while trying to set same target field (Virtual) in 2 different target tables under the same transform map.

Error - "An existing map to this target field already exist"

My requirement is to set the target field "Is Virtual(virtual)" for 2 target tables in the same map. Below are the 2 target tables am trying to map the field to

cmdb_ci_lb

cmdb_ci_netgear

[Gautam Raj]

Hi Ankur,

Yes i have only 1 transform map and i want to set 2 target fields with same source value.

So in this case my onBefore transform script should be like below ? correct me if am wrong

target.Virtual = source.u_is_virtual;

[Ankur Bawiskar]

@Gautam Raj 

correct, ensure source field name and target field name are correct.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Gautam Raj 

how the target table is different if only 1 transform map is there?

1 transform map will have 1 target table and all field maps under it should be for the same target table as that of the table defined in transform map

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Gautam Raj 

I believe you have 2 transform maps and each transform map is having same source field but different target field on those 2 separate tables?

If my response helped please mark it correct and close the thread so that it benefits future readers.