Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all,
I have two tables as per below. table 1 - information and table 2 - sales.
table 1
NO | details |
A1 | item 1 |
A2 | item 2 |
A3 | item 3 |
A4 | item 4 |
table 2
No | Amount |
A1 | 1.55 |
A1 | 2.1 |
A2 | 1 |
A2 | 5 |
A3 | 3.6 |
expectation output:- (add column in table 1 )
NO | details | total sell |
A1 | item 1 | 3.65 |
A2 | item 2 | 6 |
A3 | item 3 | 3.6 |
A4 | item 4 | 0 |
*Due to some reason both table are not associated. Kindly advice to set expression
Hi there, check this out:
[table 1]:
Load
NO,
details
From YourBase;
Left Join([table 1])
Load
No as NO,
Sum(Amount) as TOTAL
From YourBase
Group By No ;
Regards
@Thiago_Justen_ hi, but the table cant be joined due to some reason. Any way to make it done? like, set expression??
@Ravin1 they'll be joined by same name column (NO). That's the why I renamed "No" field from table 2 to "NO".
Give a try and then call me again. It'll be a pleasure help you with this.
hi @Thiago_Justen_ the table cant join due for some reason. These tables are simple only and the concept is the same.
Are you able to take a screenshot with your script?
@Thiago_Justen_ do you have any other solution instead of editing the script?