Importing Data from Excel with Import Wizard

I am importing data from an Excel file with the Import Wizard. I check Column name as header, Empty fields are null and Normalize columns. After normalizing columns, Date_, Code, Code Value and an extra mnemonic column is added. How do I import without having the extra mnemonic column?

Does anyone have any insight to do this?

After you select to normalize your columns there is configuration box that requires you to set the names of the two extra columns. On the next tab you can remove any columns you want and perhaps only export the normalized columns. That is how we designed it.

@e.chin Evelyn, can you send us your Excel spreadsheet or a sample of it and add a screenshot of the issue here? Thanks

Hi @dan,

I'm a colleague of @e.chin with the identical problem. Here's a screenshot of my screen with the problem.

I'll send separate posts with screenshots of another colleague's screen without the problem.

Here's a screenshot of my other colleague's screen without the error. This is before normalization.

Here's the 2nd screenshot of my other colleague's screen without the error. This is after normalization.

Hello there,

Could you please reach out with your sample data excel sheet being attached for further investigation?

You can send your file via e-mail at: rejhan.kuc@quest.com