Retrieve Data from R

LanBiteam — Wed, 21 Sep 2022 15:34:40 GMT

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

topic Retrieve Data from R in Integration, Extension & APIs

Retrieve Data from R