Forum Discussion

LillyLegenda's avatar
LillyLegenda
Helper III
5 years ago
Solved

Invoke R-Script function to all fieles in Folder

Good morning,  I am using an R-Script to do a market basket analysis. The code is working fine and I managed to create a function call Apri.   let Apri = (Quelle) => Quelle = Report, #"R-...
Need Help
  • ImkeF's avatar
    ImkeF
    5 years ago

    Hi LillyLegenda ,

    didn't pay attention to the function itself.
    Problem with your function is that it ignores the function parameter and itself always takes table "Report" to work upon.

    Changed it to this:

     

    and its working now (see attachment).

    But it's a bad practice to name the function parameter the same as a step/variable in the query itself.
    So it would be better (and less confusing) to name it like so:

     

     

     

LillyLegenda's avatar
LillyLegenda
Helper III
5 years ago

Hi ImkeF , Thank you very much for your answer and time.

I read the links you provided and looked at the file, but I am still confused.

I would expect the function to run, when I click on one of the Tables in the column ExcelFile but it is only showing the source table. Why is it not applying the function?

Maybe the function is not recognizing the table as Source (Quelle)?

The result of the function should look like the Apriori Query