🎉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

An issue with read csv

User: "bernardo_pagnon"
New Altair Community Member
Updated by Jocelyn
Hello all,

so, I am trying to read a csv file, but I noticed something strange. If the first row has 4 entries, and the second row 5 entries, RM only reads the first 4 entries of the second row! It seems that the first row defines how many rows will be read. How can I fix the problem? I have thousands of rows, and I don't want to get into my database to find the row with the largest number of columns.

Regards,
Bernardo 

Find more posts tagged with

Sort by:
1 - 4 of 41
    User: "jacobcybulski"
    New Altair Community Member
    Accepted Answer
    I assume that your first row has missing values in the attributes far right? If so, make sure the first row has enough extra commas at the end to create those attributes with missing values. Also, I think that if you have the row with headings this row will create the necessary attributes. That should fix the reading problem. 
    User: "bernardo_pagnon"
    New Altair Community Member
    OP
    It did the trick, thanks Jacob!

    Best,
    Bernardo

    User: "jykim"
    New Altair Community Member
    I am having the same problem. And, I like the trick. Thanks to jacobcybulski. However, though typing enough extra commas will solve the problem, it doesn't sound convenient. Best semi-automatic way is probably to move a row with the longest list of columns to the first row. But I wish there was a way to do this automatically through RM setting. Any parameter changes or or setting to do it automatically? I am trying to do Create Association Rules through FP-Growth. So the data set is a grocery shopping data.
    User: "Telcontar120"
    New Altair Community Member
    In the Read CSV operator you can specify which row you should use as your header row, so you can always just pick your longest row and use that (and then rename your attributes as needed).