Hello community,
Here is my problem: I am trying to load each sheet of my excel file coming from my excel adapter (Hana Data Provisioning Agent) so that i have a virtual table for each of my sheets.
I use the command create virtual table 'name of table' at 'location and name of excel sheet' which works fine but the problem is after i get my virtual tables there is spaces in the names of the column and absolutely no commands to change the name of the columns work if there is a space in the original column name.
I tried putting the name between all sorts of brackets with no success. By the way I use xsjs to modify the data and send sql queries.
Hope you can help me!
Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.