I have a big dataset where each row is slightly different than the other. I’m trying to normalize those rows into a table using Dremio SQL. What is the best way or normalize the data?
Example below Col A
“!!” Hello World:hello hi:I’m [12:03:300]
Normalized the data