How to convert row to dict using Python transform?

[fdanielsouza]

Hi, I noticed that when we use Python Transformation, then Power Query is aware of the row we are. If we do, for example, dataset[newcolumn] = dataset[somecolumn] it will give the corresponding row value to the new column. Problem is, when we do something like str(dataset[somecolumn]), Power Query loses his awarenesess of which row it is at, instead it'll probably raise an error, or if we do something to aggregate those values it will give the entire dataframe for each row. 

Question is: how can I get Power Query to know which row it is again after do some kind of conversion? 

[Icey]

Hi @fdanielsouza ,

I am not very sure what you want to do. Do you want to convert rows into columns?

If so, how about using UnPivot or Transpose?

If not, could you share us more details?

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ImkeF]

Hi @fdanielsouza ,
not sure what's actually going on in what you're describing.
But the "problem" with Power Query is that it uses some syntax sugar when working with functions.
Therefore, using square brackets can mean that you're referencing either a column from a table or a field from a record. The later would be "row aware".
So to understand what's (not) going on in your case, I would have to understand the context in which the expressions where used.
For more, see this link: Understanding Power Query M functions - PowerQuery M | Microsoft Docs 
and for the lookup operators: Operators - PowerQuery M | Microsoft Docs