Forum Discussion

pade's avatar
pade
Advocate III
9 years ago

R script and lists does not work with Power Query

Power Query lists don't seem to survive when going through R scrip back to Power Query.

 

This simple R-script below returns a none list column, eventhough the column was a list in the earlier Power Query step

 

---

# 'dataset' holds the input data for this script
save(file="dataset", dataset)
output <- dataset

---

 

Is this by design, a bug, or something that I do wrong?

2 Replies

  • pade's avatar
    pade
    Advocate III
    9 years ago

    The reason for mecreating the simple example above was that I didn't manage to create a list in R and send it back to Power Query. E.G.

    output <- dataset

    output$NewListColumn <- list(1:3))

     

    and then back in Power Query expand that column

     

    Before R:

    OriginalColumn

    ==========

    A

    B

    C

     

    After R (and Power Query), it might look something like this:

    OriginalColumn, NewListColumn

    ==========, ==========

    A, 1

    A, 2
    A, 3
    B, 1

    B, 2

    B, 3

    C, 1

    C, 2

    C, 3

     

     

    • v-micsh-msft's avatar
      v-micsh-msft
      Microsoft Employee
      9 years ago

      Hi pade,

      I just tried the

      save(file="dataset", dataset)
      output <- dataset

      And it returns the column entered in Query Editor;

      For

      output <- dataset

      output$NewListColumn <- list(1:3))

      I think there should be one “ ) “ in <- list(1:3))

      In addition, what would you like to achieve, to use R List function here? Maybe we could achieve that through other ways.

      Regards