Check if values in one column appear in another column

Hi Community,

I have a scenario where For a Given ID…We can have an Old_ID in the System.
I want to compare created_date of ID with the Created_date of its corresponding ID.

In above Table -
For ID 2 the Created_Date is Jan 1… And Its Old_ID 1 (when looked up in ID column)…have a Created_Date Dec 24… I want to find Date Difference between created_date of id 2 and created date of id 1.

QC

I have multiple rows in the Table and ids can’t be sorted in any specific order.

Thanks.
Looking for reply from community.

@Vivek54 Hi
I think you have to take care of this in the data-processing step