How do I lookup values and replace from another table that has delimited values?

ComputerHabit The correct way to do this is to split the job id into rows by delimiter and then each row will have a single job id. Once this change is done, you can either merge with the job table in PQ or just set a relationship in the model between two tables and should be able to pull the relevant information from the job table.

Keep in mind, that the best practice is to get the detailed data by row, and in your case that is not the case. There will be other solutions but will refrain as they will complicate things for no reason and can have performance issues on large datasets.