2 Replies Latest reply on Jan 18, 2019 7:27 AM by Daniel Bradley

    state categories




      I have created a table and the first column includes some states, and the second column includes some IDs associated with those states.

      As you see in the screenshot below, I have "MI" in the first column and it has 3 different IDs associated with it. So instead of that, I need to have 3 "MI" in each row. How can I unmerge them?


      Thank youphoto_2019-01-18_09-34-53.jpg

        • 1. Re: state categories
          Jim Dehner

          hi you have something similar to this

          add an index to column and make discrete

          then hide the index


          results in this




          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          1 of 1 people found this helpful
          • 2. Re: state categories
            Daniel Bradley

            Hi Karinka,


            If you drag the State Pill after the ID pill on the rows shelf you will get a state value for every ID


            Hope this helps