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 _})
PC2790's avatar
PC2790
Community Champion
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() }})