"How can I refresh an imported Excel file inside the repository whenever this file is changed?"

Prentice
Prentice New Altair Community Member
edited November 2024 in Community Q&A
I have imported an Excel file inside my repository. The contents of this file are modified from time to time. Is there some sort of operator that automatically refreshes this before I retrieve the file?
Tagged:

Best Answer

  • varunm1
    varunm1 New Altair Community Member
    Answer ✓
    Hello @Prentice

    If you imported the file into Repository, you cannot get the new updated rows or columns in your original excel file. You should reimport data again. 

    For this reason, you have a read csv or excel operator in rapidminer. This will get the updated file whenever you apply this as this points to the location where the files are saved rather than saving them in the repository.

Answers

  • varunm1
    varunm1 New Altair Community Member
    Answer ✓
    Hello @Prentice

    If you imported the file into Repository, you cannot get the new updated rows or columns in your original excel file. You should reimport data again. 

    For this reason, you have a read csv or excel operator in rapidminer. This will get the updated file whenever you apply this as this points to the location where the files are saved rather than saving them in the repository.
  • Prentice
    Prentice New Altair Community Member
    Ah ok, Thanks
  • IngoRM
    IngoRM New Altair Community Member
    @varunm1 is right, please consider using data loading via an operator instead of import if this happens on a regular basis.  The following video from our Academy may be useful:
    Hope this helps,
    Ingo

Categories