Skip to Content

Merge causes rows to multiply- Webi

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers