Can't see attributtes in operator right next to Read Excel
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"?>
Find more posts tagged with
Sort by:
1 - 2 of
21
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úl
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úl
Sort by:
1 - 2 of
21
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,
Marco
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,
Marco
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úl
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úl
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,
Marco