Hi
I am trying to replace concat with auto load in script, and while trying to do it, all Dimension tables are populated well, and everything is fine with the dimension tables. But in fact table, something is happenning and reload always resulted in an error ODBC read failed
ODBC connection statement is correct, and I have searched community and found something saying "If alias name is removed from LOAD statement it would work"
http://community.qlik.com/message/74777#74777
And yes, In Fact table suppose need 10 fields, 5 are direct columns from tables in database, while the other 5 are aliases like case statement aliases.
When I comment the aliase named fields in fact table, and reload, the reload is successful and everything is alright
But I want the other fields also.. and I don't think the problem is with alias names...as all the Dimension tables also contain direct field names from column names of a table and alias names as well..the Dimension tables are pretty well populated.
Can anyone help this out..
Thanks,
Priya