topic Table Join in App Development

Table Join

americanetsMD — Mon, 28 Aug 2023 19:22:56 GMT

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.

Re: Table Join

E_Røse — Mon, 28 Aug 2023 19:56:29 GMT

Are you sure you want a join here?

You can add inner keep(Tab1) or

inner join(Tab1) on the row above Tab2

Re: Table Join

americanetsMD — Mon, 28 Aug 2023 20:31:18 GMT

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..

Re: Table Join

Vegar — Tue, 29 Aug 2023 06:45:30 GMT

This should be correct syntax for a Join.

Table:

Load

KreditorNr,

Group

FROM SourceA;

Inner join (Table)

LOAD

DebitorNr,

Group

FROM SourceB;

Re: Table Join

americanetsMD — Tue, 29 Aug 2023 09:22:11 GMT

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.