Multiple rows to Single row in Tableau | Group_Concat in Tableau | Tableau real time use case
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!
I don't know, but the most brilliant and useful Tableau tips I've seen for the past 5 years
Wow, thanks!
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
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
THX very useful
Glad to hear that
Great tip. Thanks for sharing
Thanks for watching!
Great content!
Thank you!
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 ?
Glad it helped! Please join as a member to support this channel czcams.com/channels/MyjwXfdnf1ezjJyUDHXrsA.htmljoin
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
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.
I will try my best, thanks for the feedback!
Its getting difficult while i am adding sone other fields
Slow down and explain each step. What your doing and why your doing it. It's not a race.
time waste video....why this much complex ? simple use index() as s.no and hide it as first row
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.
@@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