Options
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
-
Options
Marco_Boeck
Administrator, Moderator, Employee, Member, University Professor Posts: 1,993 
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 -
Optionsraulsamaniego
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
