Have been spending my Sunday to make this solution: it selects people using their jobtitle (JT) and compares that to a Keywords table to determine is somebody fits a certain position.
Position e.g. "developer" or "digital analyst". Keywords are e.g. "digital", "analytics", "analysis" etc
The results are written to a table QualifiedFor.
Everything works how it should, except for one thing: while the right Keyword ID (KID) is shown, the Keyword does not change:
KID and Keyword are both filled together in the script.
KID and Keyword also come from one table.
See attached files.
Can never be complicated but I don't see it anymore
Thanks for the advice!