The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 Blank Rows", {{"CoolColumn", each if _ = null then Text.NewGuid() else _ } } )
Any thoughts on how to make each row have a unique GUID ?
Regards,
Rajesh
Solved! Go to Solution.
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 _})
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 _})
Thanks! The workaround did the trick for me.
Regards,
Rajesh
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() }})
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
20 | |
19 | |
14 | |
13 |