Skip to Content
0

Merge causes rows to multiply- Webi

Feb 10 at 10:19 AM

29

avatar image

Hi guys

Is there a way to force the result of a query to have unique rows when merging?

Here is the scenario..

Table 1- unique list of plan change details by Customer_no

Old_plan New_plan Plan_change_date Customer_no

ABC D_ABC 01/01/2015 12

ABD D_ABD 24/07/2016 13

DEW D_DEW 09/09/2017 15

Table 2 - details of plans by customer

Customer_no Plan_type effective_date profit

12 ABC 12/12/2014 12%

12 D_ABC 01/01/2015 13%

12 E_ABC 12/01/2015 14%

13 ABD 22/07/2016 8%

13 D_ABD 24/07/2016 12.5%

Expected result

I need to show the profit % of plans by customer based on the plan change date

Customer_no Pre_change_plan Profit1 at_change_plan Profit2 Post_chng plan Profit3

12 ABC 12% D_ABC 13% E_ABC 14%

13 ABD 8% D_ABD 12.5%

How do I achieve this in Webi?

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers