data type change in data manager or script

[louise119]

When loading data from DBk, it is interpreted as a number even though it is a character string. How can I change the data type with data manager or script?

[vinieme12]

force the field as text using TEXT() function

example

TableName:

Load 

fieldA

,fieldB

,TEXT(fieldC) as  fieldC

; SQL Select

fieldA,fieldB,fieldC

From db.sqlTable;

[louise119]

Thank you ,

I have the same table in the auto-generated section, should I delete the original table?

[vinieme12]

you can modify the existing script

[louise119]

How can I modify the auto-generated script?
If I unlock the auto-generated script, I can't see the data manager , right?

[vinieme12]

Unlock the Script and Edit it

You can continue to add new Data sets either using Data Load Manager or Data Load Editor

[louise119]

I've tried, but the data manager becomes unusable. I tried synchronizing the table from the script, but it ends with an error.