Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am trying to get rid of synthetic key and thinking to use a linktable. considering i am very new to all this, can you please suggest a good reference and steps to follow please.
Thanks very much.
I suggest go for this book -
Hi! Have you considered creating a key field?
Table1:
LOAD
Field_A,
Field_B,
Field_C,
Field_D,
Field_A & '-' & Field_B AS Key
FROM ...
Table2:
LOAD
// Field_A,
// Field_B,
Field_E,
Field_F,
Field_A & '-' & Field_B AS Key
FROM ...