unable to create compound fields

[Former Member]

Hi all,

I created a qualified lookup table "Contact person" which has 1 qualifier field: Name and 2 non-qualifier fields: prefix and telephone.

After I maped the two non-qualifier field with table "Contact person", my next step is to go to main table "business partner" to map qualifer fields and then create a compound field and map this compound field with "contact person" field in main table. From a user guide I read that a compound field can only be made after all non qualifer fields are also mapped with the destination field in main table,

but the fields appear in the main table are just "F contact person" and "Name<contact person>", the non-qualifer do not appears at all, could anyone tell me how I can create a compund field? thanks a lot!

Bin

[Former Member · Accepted solution]

Hi Bin,

Non Qualifier fields needs to be mapped in the Qualified table where it will appear.

Also the Qualifier fields will not appear in Qualified table but in Main table.

Once those two non-qual fields gets mapped to the main table, select/highlight any one field in the source and right click on it , select the 'create compound' option when the compund field will automatically appear or gets enabled in the drop down.

One have to just select and click the compound field that got enabled to get automatically mapped.

Hope this helps.

-reo

[Former Member]

<u><b>Compound Field Creation</b></u>

Combines fields that have been mapped to multiple display fields of a destination lookup field.

Example:

If you have a lookup table with two display fields namely State and City.

In the import Source file, if you have two separate columns. one for State and one for City.

In this case, map the source State field to Display field State.

Map Source City field to Display field City.

After mapping both the display fields, now choose Source State and Source City field and right click.

Choose Create Compound field and choose the compound field.

Once chosen, a new compound field is created in the source side of the map, and it automatically maps to the Combined display fields in the destination.

Hope this helps.