5 Replies Latest reply on May 28, 2018 4:23 AM by Umesh Lohani

    How to count the no of records when one dimension occurs inside another dimension values

    Umesh Lohani

      Hi Everyone,

       

      problem set:

       

      I wants to count the no of records when one dimension occurs inside another dimension in another dataset.

       

      I have used contains([String],[Substring]) , but this approach is not giving the expected result.

       

      Both the dataset have only country & somecode as a common column.

       

      when I use second column 'somecode' for a blending than only I gets the result using above formula( contains([String],[Substring]))

       

      Is there any approach available to count the number of records without using the second column in blending.

       

      Thanks.

      BR

      Umesh

       

      I am attaching the Sample workbook. In the workbook , I am using Contains and searching the Substring from Dataset2 within String in dataset1. After using the Contains function , I want the substring2 description also from Dataset2. Is there any way to get the Substring 2 description from dataset2 in sheet1. Attaching the Sample workbook for your reference. Message was edited by: Umesh Lohani