Comments
-
FYI, just adding on the solution - to solve the error "Identifier name must be 64 characters or less" in MySQL, one feasible way around is to use Magic ETL to rename that column to create a new Dataset so that can be used in the MySQL Dataflow!
-
Hi Darius, Thank you for the resource. I did add indexes before join, with that being said, I guess the text columns are the bumps. Thank you again! Cheers, Luna
-
Hi Darius, Thank you for letting me konw there is no hard limit. I'm using SQL. There are 17 columns, and 6 of them are text, while the rest are numeric. Two of the text columns can take up to 200 characters. I guess they are probably the reason why the dataflow is running slow. Cheers, Luna
-
Hi Aaron, Thank you for the idea! However, the visitor for "In-Market" is not the sum of other rows, which is why I need to use that exact cell value, so I don't think I can use the function you suggested. The reason why I didn't do these calculations in data flows is because the denominators for the different categories…