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 in Tableau by Vaani
• 6,820 points
87 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 by Neha
• 8,560 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 in Tableau by Neha
• 8,560 points
57 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,230 points
1,626 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,230 points
561 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,010 points
574 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
2,945 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
3,912 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
163 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
209 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 in Tableau by Neha
• 8,560 points
32 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 in Tableau by Neha
• 8,560 points
35 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP