Joining tables

[AB108]

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.

[E_Røse]

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;

[AB108]

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)

[sidhiq91]

@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: