Flatten data in Tableau (not exactly pivot)












1















I am looking for flattening the data in Tableau as shown below:



Following is the input format I have:



ID CUST_ID GROUP Code



1234 25 HAN1 MD



1234 25 RO HN



1234 25 WL C



1234 25 M NAPP



2345 8 HAN2 MR



2345 8 RO HN



2345 8 WR SW



Following is the output format:



ID CUST_ID GROUP Code Group Code Group Code Group Code



1234 25 HAN1 MD RO HN WL C M NAPP



2345 8 HAN2 MR RO HN WR SW



I know I can achieve that using a programming language but I am not able to get in Tableau. Can anyone please help with that?






tableau







share|improve this question



























    1















    I am looking for flattening the data in Tableau as shown below:



    Following is the input format I have:



    ID CUST_ID GROUP Code



    1234 25 HAN1 MD



    1234 25 RO HN



    1234 25 WL C



    1234 25 M NAPP



    2345 8 HAN2 MR



    2345 8 RO HN



    2345 8 WR SW



    Following is the output format:



    ID CUST_ID GROUP Code Group Code Group Code Group Code



    1234 25 HAN1 MD RO HN WL C M NAPP



    2345 8 HAN2 MR RO HN WR SW



    I know I can achieve that using a programming language but I am not able to get in Tableau. Can anyone please help with that?






    tableau







    share|improve this question

























      1












      1








      1








      I am looking for flattening the data in Tableau as shown below:



      Following is the input format I have:



      ID CUST_ID GROUP Code



      1234 25 HAN1 MD



      1234 25 RO HN



      1234 25 WL C



      1234 25 M NAPP



      2345 8 HAN2 MR



      2345 8 RO HN



      2345 8 WR SW



      Following is the output format:



      ID CUST_ID GROUP Code Group Code Group Code Group Code



      1234 25 HAN1 MD RO HN WL C M NAPP



      2345 8 HAN2 MR RO HN WR SW



      I know I can achieve that using a programming language but I am not able to get in Tableau. Can anyone please help with that?






      tableau







      share|improve this question














      I am looking for flattening the data in Tableau as shown below:



      Following is the input format I have:



      ID CUST_ID GROUP Code



      1234 25 HAN1 MD



      1234 25 RO HN



      1234 25 WL C



      1234 25 M NAPP



      2345 8 HAN2 MR



      2345 8 RO HN



      2345 8 WR SW



      Following is the output format:



      ID CUST_ID GROUP Code Group Code Group Code Group Code



      1234 25 HAN1 MD RO HN WL C M NAPP



      2345 8 HAN2 MR RO HN WR SW



      I know I can achieve that using a programming language but I am not able to get in Tableau. Can anyone please help with that?






      tableau




      tableau






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 17 '18 at 22:46









      gagangagan

      63128




      63128
























          1 Answer
          1






          active

          oldest

          votes


















          1
















          1. Create a calculated field "GROUP_CODE" as below



            enter image description here




          2. Build the view as Below



            enter image description here








          share|improve this answer
























          • Thank you Jose.. I also want to get the column names in my view and maintain the sorting list I shown in my example.

            – gagan
            Nov 18 '18 at 12:41











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53356274%2fflatten-data-in-tableau-not-exactly-pivot%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          1
















          1. Create a calculated field "GROUP_CODE" as below



            enter image description here




          2. Build the view as Below



            enter image description here








          share|improve this answer
























          • Thank you Jose.. I also want to get the column names in my view and maintain the sorting list I shown in my example.

            – gagan
            Nov 18 '18 at 12:41
















          1
















          1. Create a calculated field "GROUP_CODE" as below



            enter image description here




          2. Build the view as Below



            enter image description here








          share|improve this answer
























          • Thank you Jose.. I also want to get the column names in my view and maintain the sorting list I shown in my example.

            – gagan
            Nov 18 '18 at 12:41














          1












          1








          1









          1. Create a calculated field "GROUP_CODE" as below



            enter image description here




          2. Build the view as Below



            enter image description here








          share|improve this answer















          1. Create a calculated field "GROUP_CODE" as below



            enter image description here




          2. Build the view as Below



            enter image description here









          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 18 '18 at 2:47









          Jose CherianJose Cherian

          3,20812327




          3,20812327













          • Thank you Jose.. I also want to get the column names in my view and maintain the sorting list I shown in my example.

            – gagan
            Nov 18 '18 at 12:41



















          • Thank you Jose.. I also want to get the column names in my view and maintain the sorting list I shown in my example.

            – gagan
            Nov 18 '18 at 12:41

















          Thank you Jose.. I also want to get the column names in my view and maintain the sorting list I shown in my example.

          – gagan
          Nov 18 '18 at 12:41





          Thank you Jose.. I also want to get the column names in my view and maintain the sorting list I shown in my example.

          – gagan
          Nov 18 '18 at 12:41


















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid …



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53356274%2fflatten-data-in-tableau-not-exactly-pivot%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          -

          Popular posts from this blog

          Guess what letter conforming each word

          Image
          6 $begingroup$ This is an entry in the Fortnightly Topic Challenge #41: Short and Sweet. 1 letter only could be mean anything . With an additional letter in front , could be used as medicine component and something you definitely learn or at least heard once. Add another letter in front , you would possibly hear that many times . Add an additional letter in front , you would found an independent country . With an additional letter, in the end , you would found something related to apple . Add another letter in the end , you would found something bad . Hint: Each letter is unique . word knowledge letters chemistry share | improve this question ...
          Read more

          Port of Spain

          Image
          For ports in the country of Spain, see List of ports in Spain. City in City of Port of Spain, Trinidad and Tobago Port of Spain City City of Port of Spain Top to bottom (left to right): Skyline of Port of Spain from Gulf of Paria; National Academy for the Performing Arts, Independence Square, Eric Williams Plaza; MovieTowne, Port of Port of Spain Motto(s):  "We Gather Strength As We Go Along" Port of Spain Coordinates: 10°40′N 61°31′W  /  10.667°N 61.517°W  / 10.667; -61.517 Coordinates: 10°40′N 61°31′W  /  10.667°N 61.517°W  / 10.667; -61.517 Country   Trinidad and Tobago Jurisdiction City of Port of Spain Settled 1560 Incorporated (town) 1853 Incorporated (city) 1914 Government  • Mayor Joel Martinez  • Governing body City Corporation Area [1]  • City 12 km 2 (5 sq mi) Elevation [2] 66 m (217 ft) Population (2011) [1]  • City 37,074  • Rank 3rd  • Density 3,090/km 2 (8,000/sq mi)...
          Read more

          Run scheduled task as local user group (not BUILTIN)

          Image
          0 I am trying to run a scheduled task with User Group (not a single user). This is working fine when I in the field "when running a task, use the following user account:" insert BUILTIN User Group (for example: Administrators or Users). But when I try it with the created Local User Group (example: TestGroup) it is not working. The Users in the TestGroup are the same as in the Administrators group. What could be the problem? Are there some restrictions to the Created User Group compared to BUILTINUsers? scheduled-tasks taskscheduler windowstaskschedule share | improve this question asked Nov 15 '18 at 15:36 Far...
          Read more