Multiple rows to Single row in Tableau | Group_Concat in Tableau | Tableau real time use case

Sdílet
Vložit
  • čas přidán 5. 07. 2021
  • Multiple rows to Single row in Tableau | Group_Concat in Tableau | Tableau real-time use case
    In this video, I have explained how to implement Group concatenate in Tableau using First, Last, and Previous value functions.
    Like and Share my videos and SUBSCRIBE to my channel if you find this content helpful.
    Thanks for your support!

Komentáře • 20

  • @bmwslamdunk
    @bmwslamdunk Před 5 měsíci

    I don't know, but the most brilliant and useful Tableau tips I've seen for the past 5 years

  • @swapnaakanamarla541
    @swapnaakanamarla541 Před 2 lety +2

    Amazing video Sir. You are an expert.
    Please make videos on row level security both manual and automation process. It should be very helpful to many of us

    • @TableauTip
      @TableauTip  Před 2 lety

      Thanks for the comment.
      To support this channel and get priority reply to your comments, please join this channel.
      Link to Join - czcams.com/channels/MyjwXfdnf1ezjJyUDHXrsA.htmljoin
      How to Join ? czcams.com/video/Y0LZB1Vga3E/video.html
      - Tableau Tip Team

  • @user-hk2uj7jl4g
    @user-hk2uj7jl4g Před 3 měsíci

    THX very useful

  • @meenuchoudhary8759
    @meenuchoudhary8759 Před 3 lety

    Great tip. Thanks for sharing

  • @mhtkhan302
    @mhtkhan302 Před rokem

    Great content!

  • @archisha8849
    @archisha8849 Před 2 lety

    Thank you, This is very helpful. If I want to display the same last row (ie the aggregated row) for each ship mode, how to achieve it ?

    • @TableauTip
      @TableauTip  Před 2 lety

      Glad it helped! Please join as a member to support this channel czcams.com/channels/MyjwXfdnf1ezjJyUDHXrsA.htmljoin

  • @akshathaiyer5837
    @akshathaiyer5837 Před 8 měsíci

    This was very helpful. But I am not sure when I filtered out the last() to 0 it shows only 1 row as a result like the last row which has all concatenated. Any idea why so ? The indexing of last() shows according to the seggregation of the categories but when I filter it shows only one row

  • @datavizenthusiast3560
    @datavizenthusiast3560 Před 3 lety

    Sir awesome tips . ,And Watching your videos I can feel you have awesome knowledge. But Please make the flow go smooth. It will reduce length of video. And also make it look great output. Anyways thanks a lot for all ur videos.

    • @TableauTip
      @TableauTip  Před 3 lety

      I will try my best, thanks for the feedback!

  • @akhilssc7405
    @akhilssc7405 Před 7 měsíci

    Its getting difficult while i am adding sone other fields

  • @bobbaran4589
    @bobbaran4589 Před 3 měsíci

    Slow down and explain each step. What your doing and why your doing it. It's not a race.

  • @user-nu7jl3lc2d
    @user-nu7jl3lc2d Před 2 lety

    time waste video....why this much complex ? simple use index() as s.no and hide it as first row

    • @TableauTip
      @TableauTip  Před 2 lety +1

      Thanks for your comment. I believe index function alone will not serve the purpose. In order to concat rows you must use Previous value function. Hope this helps! Please do let us know detailed steps if there is a better way.

    • @sanagaribabu7956
      @sanagaribabu7956 Před rokem

      ​​@@TableauTip when we have same ship mode ..eg -- 1st class appreas twice should display only once in concat how to do?
      When different (1,2) should display...1,2
      When 1,1 display 1
      When 2,2 display 2