Link tables on created field

[RobinB]

Good day

I need some help linking my tables whilst loading.

I need my tables to link on a combination of nappi and nappi-ext, not just nappi.

Below are two tables that I need to link. 

There is a field "nappi-we" that is a combination, on the table to the left. Is this correct?

How do I change my load script to achieve this link in other tables?  

Thanks

C

[vchuprina · Accepted solution]

Hi,

It's correct, but I recommend you add some symbol between fields for instance |

[p-nappi]&'|'&[p-nappi-ext] as [p-nappi-we]

[i-nappi]&'|'&[i-nappi-ext] as [p-nappi-we]

Regards,

Viltaii

[vchuprina]

Without a symbol between fields in the composite key, you can link the wrong data, for example

OrderID	ProductID	Key (Order&Product)	Key (Order&'|'&Product)
1	1	11	1|1
2	1	21	2|1
2	2	22	2|2
3	1	31	3|1
4	1	41	4|1
11		11	11|