Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Can't see attributtes in operator right next to Read Excel
raulsamaniego
Member Posts: 9 
Contributor II
in Help
Hi There,
I can see examples and attributes AFTER Read Excel operator but just examples with NO attributes BEFORE the operator right next to Read Excel.
It happens only when selected range in Excel File contains a dynamic table connected to a BI Database
<?xml version="1.0" encoding="UTF-8"?>
I can see examples and attributes AFTER Read Excel operator but just examples with NO attributes BEFORE the operator right next to Read Excel.
It happens only when selected range in Excel File contains a dynamic table connected to a BI Database
<?xml version="1.0" encoding="UTF-8"?>
1
Best Answers
-
Marco_Boeck
Administrator, Moderator, Employee, Member, University Professor Posts: 1,996 
RM Engineering
Hi,
Because the Read Excel operator knows nothing about your Excel file until it has actually read it. There is a way to teach it beforehand though: Use the import wizard parameter of the operator to configure how the Excel file should be imported. Then it knows about the columns, their names and types, etc.
Regards,
Marco7 -
raulsamaniego
Member Posts: 9 Contributor II
Hi Marco,
Thank you!, It worked very well.
I used ICW, unmarked "Define header row", changed names (from A, B, C... to different ones) and marked "Replace errors with missing values" but I didn't changed datatypes because the ones ICW detected were ok.
Kind regards
Raúl1
