Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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"?> wNomHoja BI ENERO 2019

Find more posts tagged with

AI Studio

Excel

Accepted answers

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

All comments

Marco_Boeck

RaulSamaniego