How can I use MagicETL to update the rows with NULL Source values to have their relevant Source value, based on ID?
Starting Table
———————-
Source | ID | RankCol
———————-
plant | 100 | 1
NULL | 100 | 2
animal | 101 | 1
NULL | 101 | 2
Desired Resulting Table
———————-
Source | ID
———————-
plant | 100 | 1
plant | 100 | 2
animal | 101 | 1
animal | 101 | 2
Any help is GREATLY appreciated!