2 Replies Latest reply on Sep 20, 2019 12:20 AM by Norbert Maijoor

    Generate data for columns based ont eh availability of other columns

    Jasmine Singha

      Hi All,

       

      Can we deal with the below requirement in Tableau

       

      I have below columns

       

      Col A     Col B               Col C                    Col D

      212121   54564556     122121                    232334

      21212     34344          123122432432          1233213

      65656      232               24324                         Null

      87856    23434               13232                    Null

       

       

      Now , I need to check if for every record in Col C is there a data available in Col D,

       

      - if available then I will consider corresponding data of Column B as my new column E and corresponding data of Column A as new column COl E

       

      - if not then no need to generate

       

       

      I hope I am able to make understand

       

      Thanks in advance .