Trouble reading an XLSX file into Altair Analytics Workbench?

Nico Chart_21517
Nico Chart_21517
Altair Employee
edited June 2023 in Altair RapidMiner

Issue

Reading an Excel sheet causes the following error:

NOTE: SELECT `Store`,`Year`,`Week`,`UPC`,`Description`,`Reg Retail`,`RET QTY`,`Instore RET`,`Instore Qty`,`Trimester Ret`,`Tri QTY`,`Fyler`,`Flyer Qty`,`TOTAL`,`Total Qty`,`# SAP`,`PLANO`,`CATEGORIES` FROM `STR4857$`
_N_=1 _ERROR_=1 Store=. Year=. Week= UPC=. Description= Reg__Retail=. RET_QTY=. Instore_RET=. Instore_Qty=. Trimester_Ret=. Tri_QTY=. Fyler=. Flyer_Qty=. TOTAL=. Total_Qty=. __SAP=. PLANO= CATEGORIES=.
ERROR: A database error occurred. The database specific error follows:
DATABASE error: No value given for one or more required parameters.
NOTE: 0 observations were read from "STR4857$"
WARNING: Data set "WORK.STR4857" may be incomplete. When the step finished it had 18 variable(s) and 0 observation(s)

Solution

Locate the erroneous column by deleting each one in turn and re-running script until there's a successful outcome.

If there are other columns of the same look and feel and have the same format type that correctly read in then re-insert the erroneous column, and check there is no space at the beginning of the column name. Such a condition causes the above error, remove the space and re-try. Table should now read in. In this case the error was on the first row with a name ' Total Qty'.

Tagged:

Categories