Skip to Content
0
Nov 20, 2018 at 11:38 AM

How to remove space in column name of a virtual table from excel adapter?

80 Views Last edit Nov 20, 2018 at 12:04 PM 3 rev

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.