video1.0<iframe src="https://www.loom.com/embed/9f8ddf4be1674beba4fbb5dd1c959ecd" frameborder="0" width="1110" height="832" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>8321110Loomhttps://www.loom.com8321110https://cdn.loom.com/sessions/thumbnails/9f8ddf4be1674beba4fbb5dd1c959ecd-9a290455dbdc69a8.gif103.8933In this tutorial, I demonstrate how to perform a simple text-based lookup using a CSP file containing employee information and another CSP file with department details. The HR department needs to match the department ID with the department name. I guide through the process of setting up the lookup transformation, mapping the fields, and handling errors. No action requested from viewers.