Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
LanBiteam
Partner - Contributor III
Partner - Contributor III

Retrieve Data from R

Hello,

I am trying to call my R script in Qlik Dataload editor. I have installed the R Plugin and I am able to run the R examples provided. 

But since I am very new to R. I found this script online but cannot get it work. 

**************************************************

Set vRSource = 'C:/PROJEKTE/R/Forecast/';

FACT:
LOAD
*,
'$(vRsource)' as RSource
FROM [lib://FORECAST/Forecast/GP Orders - 5.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);

Forecasts:
NoConcatenate Load *
Extension R.ScriptEval ('
Source(paste0(unique(q$RSource)[1],"Test_R.R"))
forecast_attendances(q)
' , FACT);

**************************************************

The Error says: "

Connector reply error: grpc::StatusCode::INVALID_ARGUMENT: 'Status(StatusCode=InvalidArgument, Detail="Rserve error: Error in Source(paste0(unique(q$RSource)[1], "220914_Beispielcode_Integration Qlik.R")) :
could not find function "Source"

"

I assume there will also be problem with the part "forecast_attendances". Could someone please explain these 2 R script lines?

Many thanks!

 

Lan

Labels (2)
0 Replies