i have data with relative SLA's like in below screenshot and can i put each value in new row for the respective jobID and want it in timestamp with AM or PM. can i use a Vlookup kind if i get the new SLA's, then I don't have to change my data load every time.
I am sorry, but I don't understand what you mean. How does SLA and jobID relate to each other? The corresponding function to VLOOKUP in Qlik is applymap(). That function only works in the script though.