Is there a Loop function in Tableau Prep Problem written below

Question

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.

Answer 1

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.