filmov
tv
43 - Replace values in a column based on conditions
Показать описание
The normal method to updating the values in a column on a condition, is to:
A) Make a new calculated column
B) Delete the original column
C) Rename the new column
D) Change position of your columns
But that's 4 steps.
The video shows how to replace/update the values in a column based on conditions. This condition doesn't have to be in the column itself, it can be in another column.
00:00 Intro
01:14 Start with the 'Replace Value'-action
02:27 Get value for each row
03:24 Each If
05:07 Replace value based on condition in another column
06:36 Copying code creates conundrums
07:39 The Silly Goose Slow Method
A) Make a new calculated column
B) Delete the original column
C) Rename the new column
D) Change position of your columns
But that's 4 steps.
The video shows how to replace/update the values in a column based on conditions. This condition doesn't have to be in the column itself, it can be in another column.
00:00 Intro
01:14 Start with the 'Replace Value'-action
02:27 Get value for each row
03:24 Each If
05:07 Replace value based on condition in another column
06:36 Copying code creates conundrums
07:39 The Silly Goose Slow Method