topic Re: Create two or more associations from Data Management in Connectivity & Data Prep

Create two or more associations from Data Management

nskatzis — Tue, 20 Feb 2024 11:48:19 GMT

Hello,

I have loaded two tables.

I have created one association but I want to create a second one manually.

I try to do that on edit mode, selecting the field name and then the field from the second table I want to associate with.

Press "Associate" button but nothing happens (see association.jpg attachment).

It seems that you can do that only for the first association.

NOTE: I don't want to concatenate fields neither to rename the fiends in the data source.

luis_dgl — Tue, 20 Feb 2024 12:11:58 GMT

Hi, the data loader is not allowing you to associate the Country columns because you are not supposed to have 2 associations between the same tables.

anat — Tue, 20 Feb 2024 12:28:53 GMT

you can create a composite key by combining 2 fields