I am trying out the example downloaded from Qlik community about R and Qlik Sense integration. The connector is established successfully.
I tried to load in script editor, it shows "Connector reply error: grpc::StatusCode::INVALID_ARGUMENT: 'Rserve error: The method or operation is not implemented." The output shows loaded Titanic_data.csv successfully to Titanic table, but some argument error at EchoedColumnsFromR table. I have no idea what is wrong with R.ScriptEvalStr('names(q) <- c("sex_echo", "pclass_echo", "survived_echo"); q;', Titanic{ sex, pclass, survived });
Hope anyone can help to explain what is the root cause and how to resolve it.
I copied the script below for your reference.
Titanic: LOAD ID, pclass, survived, sex, "age", age_b, fare FROM [lib://data/Titanic_data.csv] (txt, utf8, embedded labels, delimiter is ',', msq);
// Here you can also see how the fields can be renamed after you get them from R. EchoedColumnsFromRrenamed: Load ID as ID, sex as sex_echoed, pclass as pclass_echoed Extension R.ScriptEvalStr('data.frame(q);', Titanic{ sex, pclass, ID });
// Return a table from R (in one call to to the R plugin) with two columns: SumOfRow, MulOfRow SumAndMulOfRowFromRscript: Load * Extension R.ScriptEval('q$SumOfRow = q$pclass+q$survived; q$MulOfRow = q$pclass*q$survived; qRes <- within(q, rm(pclass, survived)); qRes;', Titanic{ pclass, survived });
// If you have defined your own functions in the R plugin (FuncDefs.json) then you can call the function below instead of the script variant above // SumAndMulOfRowFromRfunction: // Load // SumOfRow as sum_pclass_survived, // MulOfRow as product_pclass_survived // Extension R.SumAndMulOfRow(Titanic{ pclass, survived });
ScalarLoadFromRscript: Load IDT1 as IDT1, // SSE call with the script function 'ScriptEval' passing the ID variable to the plugin // Note that the SSE call is scalar from the load script, hence there will be 4 calls (in this case) to the plugin. R.ScriptEval('q$IDT1 + 10000;', IDT1) as IDT1FromR Resident Table1;
