Is there an easier way to concat all columns? We have several tables with >50 columns where we need to concat all column and hash them to create a unique primary key. An easier way to “select all” would be great.
Is there an easier way to concat all columns? We have several tables with >50 columns where we need to concat all column and hash them to create a unique primary key. An easier way to “select all” would be great.
Found a way to do this!
Select all columns here (in screenshot) and create a struct. then cast to string
Good one.
Thank you for sharing.
