Relations view when using sheets

[Muaaz_Bayat1]

I am using sheets as the data source, I am able to create a relation based on foreign keys. I am struggling to get the view to display a field using the relation.
This is the data:

This is the view which isnt showing the relation column:

I would like the list to use the job title based on the matching job_id

Please help in this regard, All suggestions are greatly appreciated.

[Jeff_Hager]

Relations are links to entire rows of data. If you want to pull a specific column value out of that relation, you also need a Lookup column that uses that relation.

[Muaaz_Bayat1]

You’re a lifesaver dude. TX a ton!