Is there a Loop function in Tableau Prep Problem written below

0 votes
I'm working on a number of datasets and am now cleaning them up. I have a column with phone model names in it. I'm supposed to update the phone model name to the phone brand name. For example, instead of Touch Pro2 (phone model), HTC should be used instead (phone brand). Another phone dataset comprises all phone models that relate to their respective phone brands. What I want to do is combine the two datasets (the main dataset and the phone dataset) and build a loop that says if the main dataset's model column value matches the model column value of the phone dataset, replace it with the phone dataset's brand column value.
Mar 4, 2022 in Tableau by Vaani
• 7,020 points
886 views

1 answer to this question.

0 votes
Hey, Prep lacks a built-in looping function, instead relying on set-based reasoning similar to SQL. So, given two tables with the names main dataset and phone dataset, you'd connect to the two tables.
answered Mar 28, 2022 by Neha
• 9,060 points

Related Questions In Tableau

0 votes
0 answers

Is there a possibility to generate a live reporting in tableau from jira source data?

I'm searching for a way to generate ...READ MORE

Apr 25, 2022 in Tableau by Neha
• 9,060 points
865 views
+1 vote
1 answer

Is it possible to define a color code scheme just for one column in Tableau?

Follow the below steps : Remove your current ...READ MORE

answered Jul 24, 2018 in Tableau by Atul
• 10,240 points
2,275 views
+1 vote
1 answer

Is there a specific format for importing datasets into Tableau?

Well I don‘t have a definitive answer ...READ MORE

answered Aug 1, 2018 in Tableau by Atul
• 10,240 points
898 views
0 votes
1 answer

Is it possible to do a % of Table with an attribute in Tableau?

Hi Nithin, yes it is possible to ...READ MORE

answered Mar 12, 2019 in Tableau by Cherukuri
• 33,030 points
1,134 views
0 votes
2 answers

How does data cleaning play a vital role in data analysis

Data is the core you do your ...READ MORE

answered Jul 24, 2018 in Data Analytics by Abhi
• 3,720 points
4,925 views
0 votes
1 answer

How to check if array is multidimensional or not?

Since the 'second dimension' could be just ...READ MORE

answered Nov 5, 2018 in Others by DataKing99
• 8,240 points
5,205 views
0 votes
1 answer

Cleaning data using R

Try something like this: text1='"id","gender","age","category1","category2","category3","category4","category5","category6","category7","category8","category9","category10" 1,"Male",22,"movies","music","travel","cloths","grocery",,,,, 2,"Male",28,"travel","books","movies",,,,,,, 3,"Female",27,"rent","fuel","grocery","cloths",,,,,, 4,"Female",22,"rent","grocery","travel","movies","cloths",,,,, 5,"Female",22,"rent","online-shopping","utiliy",,,,,,,' d1 <- read.table(text=text1, sep=",", ...READ MORE

answered Nov 13, 2018 in Data Analytics by Maverick
• 10,840 points
358 views
0 votes
1 answer

Clean a set of data using R

Try this: NCM <- c(5,1,3,2,4) Mbrand <- c(1,5,3,4,2) fac<-factor(Mbrand, levels ...READ MORE

answered Nov 13, 2018 in Data Analytics by Maverick
• 10,840 points
401 views
0 votes
1 answer

Is it possible open a new tab for drilldown report in Tableau after publishing it

Create a replica of the Main Report ...READ MORE

answered Apr 7, 2022 in Tableau by Neha
• 9,060 points
550 views
0 votes
1 answer

How do I create a bubble chart that is aligned in Tableau?

Put your dimension in the column shelf Put ...READ MORE

answered Apr 18, 2022 in Tableau by Neha
• 9,060 points
744 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP