We created several user defined data type, such as TIME, TIMESTAMP, STRING. I manually enter entity/field into model is fine. But when user macro import from Excel, all those user data types be converted into the data type CHAR(0)..
I have many STRING field (it is for bigQuery) and manually make correction from ER/Studio manually is too much.
I wondering if someone have a way to work around on it.
Can you include a snippet of your excel spreadsheet I can work with?