R script and lists does not work with Power Query

[pade]

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?

[pade]

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]

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