topic Joining tables in App Development

Joining tables

AB108 — Mon, 06 Feb 2023 22:38:14 GMT

Hi,

I have attached sample data and the result of what I am trying to get at.

The data is huge, dynamic and has a lot more columns that I will be using as filters/listboxes in the dashboard.

Appreciate all the inputs.

Re: Joining tables

E_Røse — Mon, 06 Feb 2023 23:27:03 GMT

What exactly is the question? How to join on column A?

table_pre: <load table1> join(table_pre) <load table2> /*To get the last field in your result, you would have to multiply columns C and P*/ load *, C*P as [nameless column] resident table; drop table table_pre;

Re: Joining tables

AB108 — Tue, 07 Feb 2023 20:31:20 GMT

Hi @E_Røse the column P does not exist.

And I am not sure if to create it in the data load since I want the value to be calculated in dashboard(the % will change if the filters are changed(eg month/year etc)

Re: Joining tables

sidhiq91 — Wed, 08 Feb 2023 06:30:39 GMT

@AB108 Please use the below expression in your Straight table:

Sum(R)/Sum(total <B> R)

Back end data is shown below:

NoConcatenate
Temp:
Load * inline [
A, B, C
123, abc, 100
123, bcd, 300
123, cde, 200
123, def, 700
123, efg, 500
123, fgh, 400
123, ghi, 600

];

Outer join (Temp)
Temp1:
Load * inline [
A, Q, R
123, zp, 30
123, pr, 80
123, qr, 60
123, dg, 50
123, bf, 90
123, mk, 40
123, pl, 20

];

Exit Script;

Front End: