How do I make existing Process (that referred to an Excel import) now recognise Read Excel pathway?
Hi there, so I started creating processes when watching this video called "Elaborate Your Time Series Analysis."
I now realise that there's a difference between importing an Excel file into RM (which I originally opted for) and referring to an Excel file via an operator like Read Excel and making the file path to the Excel file on your computer.
Problem is all my processes and operators so far refer to an Excel file I physically imported using the import wizard... but I have now deleted that file in the repository because my Excel files will be regularly updated and I realised it'd be better to use "Read Excel" and "Store" and refer to a file on my Macbook that I'll be updating,
So my question is, how or can I make these existing operators I already built now find/point to the Macbook file (instead of pointing to the physically imported file in the repository)?
I have a "Retrieve" (Dow Jones Daily info from an Excel data file) operator in one of the processes before the next one does a Fourier Transform and obviously "Retrieve" now can't access the original imported file (I deleted it), but the parameters window on the top right will only allow this operator to look in the repository? Do I have to start all over creating these processes and operators?
Also if I use the "Store" operator which is connected to the "Read Excel operator, won't "Store" stop RM reading/accessing the very latest updated version of my Excel file stored on my Macbook (assuming I can repoint these operators to the Macbook file)?
Cheers for any help!
I now realise that there's a difference between importing an Excel file into RM (which I originally opted for) and referring to an Excel file via an operator like Read Excel and making the file path to the Excel file on your computer.
Problem is all my processes and operators so far refer to an Excel file I physically imported using the import wizard... but I have now deleted that file in the repository because my Excel files will be regularly updated and I realised it'd be better to use "Read Excel" and "Store" and refer to a file on my Macbook that I'll be updating,
So my question is, how or can I make these existing operators I already built now find/point to the Macbook file (instead of pointing to the physically imported file in the repository)?
I have a "Retrieve" (Dow Jones Daily info from an Excel data file) operator in one of the processes before the next one does a Fourier Transform and obviously "Retrieve" now can't access the original imported file (I deleted it), but the parameters window on the top right will only allow this operator to look in the repository? Do I have to start all over creating these processes and operators?
Also if I use the "Store" operator which is connected to the "Read Excel operator, won't "Store" stop RM reading/accessing the very latest updated version of my Excel file stored on my Macbook (assuming I can repoint these operators to the Macbook file)?
Cheers for any help!