Hi Team, I have a scenario, Like --> I have 2 country data and now I need to merge the both. Data is in this format. Metric Country LOB Value KPI 18 MALDIVES XLOB 1 KPI 21 MALDIVES XLOB PD KPI 18 MALDIVES XLOB PD Metric Country LOB VALUE KPI 18 SRI LANKA XLOB PD KPI 21 SRI LANKA XLOB PD KPI 18 SRI LANKA XLOB ND Output : Need Output on the behalf of these are the condition : •If one country at LOB level has data and other country is PD, then treat PD as zero when adding together. •If both countries at LOB level PD then combined PD •If one country at LOB level PD and one Country ND then combined is ND. OUTPUT Metric Country LOB VALUE KPI 18 SRI LANKA & MALDIVES XLOB 0 KPI 21 SRI LANKA & MALDIVES XLOB PD KPI 18 SRI LANKA & MALDIVES XLOB ND So Can anyone look into the same and revert me. Regards, AS
