Hello,
I have a problem with the smart service ‘import csv to database’, as the column names in the CSV do not match those in the table. Is there any way to create a mapping between the two values, or do I necessarily have to create a new table that has the same field names as the csv? I would like to avoid the latter solution if possible. Thank you all.
Discussion posts and replies are publicly visible
In the smart service, you can disable parsing the header line and configure the columns yourself.
How can I do it? I've already tried changing "File has header" to false, but maybe I'm doing something wrong
I do not have any current example, but I suggest toying around with the "Column Names", "Csv Header Names", and "Database Field Names" parameters.
And, you can download the plugin from the app market and study the included documentation.
I've already done it, but without results...
I've tried also setting manually the Column Names while "File has header" is false, but I receive this Error:"java.lang.IllegalArgumentException: CSV Header Names and Database Field Names lists are not the same length".
I tried it passing the variable as vector { "column1", "column2", "column3" } and also as unique string "column1,column2,column3", but I receive the same error.
Both parameters, CSV Header Names and Database Field Names, need the exact same number of names as a list or vector.