1 Reply Latest reply on Feb 12, 2018 5:04 PM by patrick.byrne.0

    Filter data based on dimension from external file

    Karthik B

      Hi All,

       

      I have a dimension from external excel file(LocationID_DIM) and I need to create a calculated dimension, when there is a match with the FACT data(LocationID_FACT) flag it as 1 else 0

       

      LocationID_DIM     LocationID_FACT     FLAG

      1                              1                              1

      2                              2                              1

      3                              3                              1

      4                                                              0

       

       

      Karthik B