Boudrel1

Discussions

Magic ELT Data Flow Unexpected Results
Hello, I have two input data set that were trasnformed in SQL. I have two columns in each data set. Column 1 is the part name, this column is the exact same in each data set, for example: row 1, in data set 1 & 2, contans the exact same text. The ladder is true for each row in each data set. The second column is the…
How to remove special characters from cells and parse data in sql
I have data stored as text and am wanting to convert it to int with-in SQL. Currently the text reads (8'-6 11/16"). I am needing to remove the foot symbol ('), the dash (-), and the inches (") symbol. Then take each number (stored as text) and convert to int. At which point I would rebuild the cell to read 102 11/16". If…

Magic ELT Data Flow Unexpected Results
Hello, I have two input data set that were trasnformed in SQL. I have two columns in each data set. Column 1 is the part name, this column is the exact same in each data set, for example: row 1, in data set 1 & 2, contans the exact same text. The ladder is true for each row in each data set. The second column is the…
How to remove special characters from cells and parse data in sql
I have data stored as text and am wanting to convert it to int with-in SQL. Currently the text reads (8'-6 11/16"). I am needing to remove the foot symbol ('), the dash (-), and the inches (") symbol. Then take each number (stored as text) and convert to int. At which point I would rebuild the cell to read 102 11/16". If…