Hi, Is there a way to read an excel file with spaces in column names

sheenajenp over 9 years ago

Hi,

Is there a way to read an excel file with spaces in column names (ex: EMPLOYEE NAME) and write to a DB Table? It is known to me that spaces are not accepted in CDT, so is there any other way how I can read these columns with spaces and map it to be written on their respective columns on the DB Table?

Thanks!

Discussion posts and replies are publicly visible

Parents

0 Stewart Burchell
Appian Employee
over 9 years ago

Having experienced using this recently the key issue is that having a column name that matches the CDT attribute name forces you to have column names that are technical in nature, which isn't very friendly for business facing use. In order to address this, we had to introduce an intermediate step in the spreadsheet to take the business-facing content and generate (using a macro) the technical-facing content. It's not elegant but it works.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Stewart Burchell
Appian Employee
over 9 years ago

Having experienced using this recently the key issue is that having a column name that matches the CDT attribute name forces you to have column names that are technical in nature, which isn't very friendly for business facing use. In order to address this, we had to introduce an intermediate step in the spreadsheet to take the business-facing content and generate (using a macro) the technical-facing content. It's not elegant but it works.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data