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