🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

"[SOLVED] Difficulty in Creating Word Vector from Excel."

User: "waynestate13"
New Altair Community Member
Updated by Jocelyn
Hi All,

I am having difficulty  in creating a word vector from an excel input in which I am trying to convert to documents.

How do I go about reading an excel file in Rapid Miner. I am starting with Read Excel but where do I go from there to convert the data.

I am trying to do something simliar to this tutorial:
http://www.youtube.com/watch?v=vhMzUi-FMy0

expect, I do not have separate documents but one document with comments on each row.

Thank you in advance for any feedback!!! i have been going at this for a week but unable to crate a word vector.

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "jackson_reverse"
    New Altair Community Member
    I was looking for an answer to this issue as well but managed to piece it together from various forum posts. My solution:

    • Import the file as CSV (or Excel) using "Read CSV"
    • Set data type to “text” (I used the import wizard to do this on the last screen I think it was)
    • Then ran output through the “Data to Documents” operator to convert each text line into a document
    • Then ran everything through the “Process Documents” operator as usual

    Hope that helps!