I need to create a parent child relationship. Source A is transformed into Target B. There is no transformation occuring before this, so the first row will not have a parent ID. In the second row, the source is B, which was the target of the first transformation in the table, so I want the parent ID to be 1 for this row. My desired outcome is shown below.