4 Replies Latest reply on Sep 4, 2018 3:33 AM by Kaushik Birmiwal

    Seach multiple columns and populate data from another column

    Kaushik Birmiwal

      hi All,

       

      I am new to Tableau and have been facing an issue. I have data in four columns and i want run a look in first columns, and return corresponding data in fourth column. Below is an example:

       

           

      MonthNext MonthAccountSKU CodeSalesNext month sales
      2017/012017/02Easyday73932114391099
      2017/022017/03Easyday73932111099N/A
      2017/052017/06Easyday211412711171888
      2017/062017/07Spar73932117211488
      2017/062017/07Easyday211412718881360
      2017/072017/08Spar73932111488N/A
      2017/072017/08Easyday21141271360N/A
      2017/082017/09Spar211412712801214
      2017/092017/10Spar21141271214N/A
      2017/112017/12Spar73932111076513
      2017/112017/12Big Bazaar2114127682592
      2017/122018/01Spar7393211513N/A
      2017/122018/01Big Bazaar2114127592N/A

       

       

      The output needed is in the last column. For every account-SKU combination, i need to map the sales that happened in corresponding month (Next Month).

       

      I have tried combination of If and Fixed functions, but it is not working well. Any suggestions?

       

      Thank you in advance for the help.

       

      Regards,

      Kaushik