Query by id and date1-date2

suryadisuryadi Member Posts: 3 Contributor I
edited March 2021 in Help
Dear all,

I need a dialog for the user can enter or select one ID and put a period (date1 until date2), then the process query with that parameter and display the data. My data is tnc.xlsx
Why I can not read tnc.csv correctly? So I save it into tnc.xlsx and use read xls file.

Thank you very much in advance.

Warmest Regards,
Suryadi

Answers

  • kaymankayman Member Posts: 662 Unicorn
    Hard to say without knowing how the csv is structured versus the xlsx. 

    A lot of things can go wrong while importing what seams a valid csv, from picking the wrong column separator (are you using a simple space, a comma, a semi-column, a tab or even something else), to enabling/disabling the quote characters and so on.
    With xls all of these are basically already covered by the format, so you have far less impact yourself. Personally that's why I prefer xls over csv but that's not always an option of course.

    Did you try to use the import wizard when using the csv? This usually tells you pretty quickly where you are overlooking something. 
  • suryadisuryadi Member Posts: 3 Contributor I
    I can import the csv file into an excel file. The separator is a comma.
    I can do import the xlsx version of the data correctly into RapidMiner. Thank you 
Sign In or Register to comment.