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 Powe...
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