error is : ???An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.???
I have an excel with 4 columns and my database has table with columns
Column names are same. I don't understand the error. File name I am passing as process variable. Number of columns to be read is 4 as i have 4 columns in file. Table name is my datatype name and data source is jdbc/mydatabase. What am I missing?
Discussion posts and replies are publicly visible
could you please show the rest of parameters you are passing?
try converting pv!FileName to : todocument(pv!FileName) and also check the all the types are of document type
As a side note here, when loading excel to the database I always gravitate towards fn!readexcelsheetpaging() from the Excel Tools plugin. You can create a rule that utilizes this function to read from the document, manually cast values to your CDT with an a!foreach() loop, then utilize the standard Write to Datastore Entity node. Much more flexibility and consistency in my experience.
Hi Chris, please suggest how to do it without CDT
anups4671 said:Hi Chris, please suggest how to do it without CDT
You don't need a CDT, you can read data into a local variable and do whatever you want with it from there. What are you trying to accomplish without a CDT?