Is it possible to use while/do loops in MySQL in Domo Dataflows?
I have data that has varying rows of data for each identifier, from one row to 26. For each identifier, I have four different columns that change with the various rows. For each new identifier, I want to loop through the rows that follow that have the same identifier and build the row out with the unique values in these four columns. I cannot get a while/do loop to run either as part of a select statement for a table query or as an SQL transform query. For each iteration, I would like to have unique column names (dynamically) for the unique sets of values.