Can't see attributtes in operator right next to Read Excel

raulsamaniego

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"?>

wNomHoja BI ENERO 2019

Marco_Boeck

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

raulsamaniego

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

Marco_Boeck

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

raulsamaniego

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