"Excel-Import doesn't work for Strings like '4711"
Hi,
I try to import data via ExcelExampleSource, which works fine, but when I have a column like
'4711 RapidMiner always converts it as integer, but it should be nominal (value type).
In Excel it is a string as "value type".
Does anyone know the solution?
Cheers
Tom
I try to import data via ExcelExampleSource, which works fine, but when I have a column like
'4711 RapidMiner always converts it as integer, but it should be nominal (value type).
In Excel it is a string as "value type".
Does anyone know the solution?
Cheers
Tom
Sort by:
1 - 5 of
51
Here we go
<operator name="Root" class="Process" expanded="yes">
<operator name="ExcelExampleSource" class="ExcelExampleSource">
<parameter key="excel_file" value="U:\rm_sampel_excel_string.xls"/>
</operator>
</operator>
Again:
If i try to import a file like
test_var
'4711
'4712
'4713
the value type is integer
Cheers
Thomas
<operator name="Root" class="Process" expanded="yes">
<operator name="ExcelExampleSource" class="ExcelExampleSource">
<parameter key="excel_file" value="U:\rm_sampel_excel_string.xls"/>
</operator>
</operator>
Again:
If i try to import a file like
test_var
'4711
'4712
'4713
the value type is integer
Cheers
Thomas
I cannot reproduce this. If I try to import an excel file with just this string, it's correctly identified as polynominal. Could you please post your process xml?
Regards,
Marco