Hi Rachel Nelson! Thanks for sharing this question. I'm not a pro in Tableau Prep yet, but if you are keen to learn more you can sign up today for classroom training on Tableau Prep which will begin in May and June by visiting the classroom training page: Classroom Training | Tableau Software
In the meantime you can get started with free introductory training videos. Go to the Tableau Training page: Tableau Training: View Training Courses
This may help you find some answers - but always feel free to reach out to the Community team if you get stuck.
Thank you! Happy cleaning
Rachel can you share a sample of your data? Are you pulling from a database or a spreadsheet? I'm curious as to how the data is getting the blanks. If it is from say an Excel pivot table it might be easier to correct it there. Looking for info so we can help!
2 of 2 people found this helpful
Unfortunately, what you're looking to do is not possible in Prep -- yet. Today, Prep doesn't know anything about the order of your rows, an this kind of "fill down" is very order-dependent.
The good news is that this isn't an uncommon ask. It's certainly on our radar.
Thanks Isaac. I appreciate the response.
Fastest solution without using a long formula: Excel - Easily fill in blank cells with data from the cell above - IQ Accounting Solutions IQ Accounting Solutions
That's not spam.
1) Select area with data & blanks.
3) Click Special=>Select Blanks
4)Type: =A2 [or where ever you first line exist]
Thanks for posting. I also attempted this in Prep.
Everyone looking at this thread, please consider voting for this idea: https://community.tableau.com/ideas/8732 as it would provide the tools in Prep to solve this kind of problem (among many others!)
This is a problem for example when the data comes from a source you can't control. Census data downloads can have this format under certain circumstances.
I've written python code before to address this, but it's annoying to have to take such a step, and can be slightly risky if something goes wrong.
Manual solutions in Excel do not scale well.
Just wanted to know that did we get any solution for the query mentioned by @Rachel Nelson above?
Because I also have the exact same query and the data is in Excel.
Any response would be really helpful.
Thanks in advance.
If your data can contain a field to sort by, such as a row number or date, then I think there might be a way with the new version of Prep.
But as Issac said, it's heavily dependent on the order.
Thanks for your response.