Create A Custom Column Based on the Name of Another Table

[cflynn_29]

Hello,

I am trying to create Source to Destination table of my Data Sources (Similar to what the Query Dependencies view does in Power Query View Tab).

The source column contains all of my data sources (as an appended table),  what i want the destination column to return is name of the "Final Table" that all of those data sources flow into, but this is proving oddly difficult. Please assist.

[cflynn_29]

It didnt work, is it because the =Table.AddColumn(#"Renamed Columns","Custom",each Record.FieldOrDefault(#shared,[Source],null)) is in another table?

[wdx223_Daniel]

=Table.AddColumn(#"Renamed Columns","Custom",each Record.FieldOrDefault(#shared,[Source],null))