Linking Tables

[#1]

Hi, I have 3 tables that include the same column but the relationships should be 1 to 2, 1 to 3 and not 2 to 3 can this be done?

TIA

[jonathandienst]

Please explain what you need in more detail, preferably with an example that shows what you have and what you are trying to get to.

[sunny_talwar]

Do you have a sample you can share?

[Anonymous]

you should define additional fields

Table1:

commonfield as %1to2

commonfield as %1to3

commonfield,

elsefield,

Table2:

commonfield as %1to2

otherfields,

Table3:

commonfield as %1to3

morefields

but donot load explicitly commonfield for Table2 and Table3

[buzzy996]

yes,rename the fields whichever the way u like to join.

[#6]

Hello,

This is what you need?

table1:

LOAD

    [same column],

    Value,

    [same column] AS [same column3];

LOAD * INLINE [

    same column, Value

    1, 1021

    2, 321

    3, 23145

    4, 321

];

table2:

NoConcatenate

LOAD * INLINE [

    same column, quantity

    1, 4

    2, 2

    3, 5

    4, 8

];

table3:

NoConcatenate

LOAD

    [same column] AS [same column3],

    sort_order;

LOAD * INLINE [

    same column, sort_order

    1, 1

    2, 2

    3, 3

    4, 4

];