Table Join

[americanetsMD]

Hello Experts,

i need a little advice on how to join two tables in Data Editor(Script) correctly. Given is the following information:

Tab1:

Load

    KreditorNr,

    Group

FROM SourceA;

Tab2:

    DebitorNr,

    Group

FROM SourceB;

SourceA table contains:

KreditorNR  |  Group

101                 |    10010

102                 |    10020

103                 |    10030

SourceB contains:

DebitorNr    |  Group

5800                 |    10010

5910                 |    23001

5911                 |    32002

My task is to create a joined table out of the above two that would contain only DebitorNr that shares the same Group with kreditorNr.

The outputTable should look like this:

KreditorNR  |  Group     |    DebitorNr

101                 |    10010    |    5800

I would be really grateful if one of you could give me a tip on how to get the desired result.

Thank you.

[E_Røse · Accepted solution]

Are you sure you want a join here?

You can add inner keep(Tab1)  or

inner join(Tab1) on the row above Tab2

[americanetsMD]

Hi E_Rose, i have tried these types of joins and i've got no results... it gives an error when i try to create the Table on the Worksheet. Regarding your question about join... I honestly don't know what would be the best way to get the desired output Table..

[Vegar · Accepted solution]

This should be correct syntax for a Join.

Table:

Load

    KreditorNr,

    Group

FROM SourceA;

Inner join (Table)

LOAD

    DebitorNr,

    Group

FROM SourceB;

[americanetsMD]

Thank you all for your answers. The problem was actually in the Table - had too many ' ' blank rows in the Group field that was causing the server fall down.