Hi Team,
We faced an issue while loading a data from File to table ,getting error message as "Column not found".We have an input file column with special characters like "LINE#".In model Datastore the column is marked as same but while loading data from file to table in sql query,the column is changed as "LINE_". I tried the column with enclosing double quotes in the mapping editor but it gave same error message.
Could you please let me know how to handle file columns with special character names in ODI