20191112 Talend - How to use the schema xml to generate a create table statement

20191112 Talend - How to use the schema xml to generate a create table statement
-Fai Fu

1) Generate the XML of the columns you want to base the "create table" statement
2) Open the xml in the text editor
make the column lines on "one line"
3) Open the xml in Excel
use formular to help generate the correct syntax/statement for the columns
4) Test the sql

(3)
label
length
talendType

text to columns
=SUBSTITUTE(SUBSTITUTE(xx,"label=",""),"""","")