Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I am trying to read an excel file from the managed folder in the dataiku which is of "Server's Filesystem" type and reading files from "filesystem_root".
Now, I am trying to read an excel file which is present in this managed folder using the below R code and getting an attached error.
folder_name <- "DXbBXaww"
data_path <- dkuManagedFolderDownloadPath(folder_name ,paste0(path_to_folder,"file_name.xlsx"))
data <- read.xlsx(data_path ,sheet ="model_applicability")
Below is an example code that shows how to read an Excel file from a local managed folder:
library(dataiku) library(xlsx) folder_name <- "hRJwLbQS" path <- dkuManagedFolderPath(folder_name) data <- read.xlsx(paste0(path,"/xl2.xlsx"), sheetName="Sheet1") print(data)
Thanks for the response!
I have also tried with the solution which you have provided but getting an attached error and also I have verified the path which I am providing and its also looking fine.
Please consider the below configuration of my managed folder.
Managed Folder Configuration:
- Managed Folder Type: Server's file system
- Source: filesystem_root
Thank you in advance for your attention to this issue. Please let me know if you require any additional information.
The error indicates that the file is not found at the location /data/dataiku/dss_data/config/projects/.../DS Module/Input/app.
You need to check if the path is correct and the Excel file exists at that location.