Forum Discussion

rajeshchawla's avatar
rajeshchawla
Helper I
5 years ago
Solved

Using TransformColumns with newGuid for each row

Hi folks,   I'm working to replace row values in a column if it's null to a new GUID. What I have places the same GUID for each row.    #"FixMyCoolColumn" = Table.TransformColumns (#"Removed Blan...
Need Help
  • PC2790's avatar
    PC2790
    5 years ago

    It is a know issue with Text.NewGuid().

    Try a workaround like:

    = Table.TransformColumns(#"Removed Blank Rows",{"CoolColumn", each if _=null then try error Text.NewGuid() otherwise Text.NewGuid()  else _})
rajeshchawla's avatar
rajeshchawla
Helper I
5 years ago

Thanks! The workaround did the trick for me.

 

Regards,

Rajesh

Anonymous's avatar
Anonymous
Not applicable
5 years ago

 

 

Table.TransformColumns(lastTab,{{"Column2", each let tng=Text.NewGuid() in if _=null then tng else _}})

 

 

I had never come across this interesting feature before. The problem seems to be circumvented even so or by filling in a whole new column of NewGuid and then taking the ones you need from here

 

or, perhaps the best way:

 

Table.TransformColumns(lastTab,{{"Column3", each _??Text.NewGuid() }})