Problem with multiple lookup conditions on a single tmap
Hi everyone, I'm really new to Talend and require some help with a tMap component I'm trying to build.
I've been tasked with performing multiple lookups on a single lookup table to create different variables, but with each lookup being slightly different. For example, varA requires a match to lookuptable.colX, while varB requires a match to lookuptable.colZ.
I know this is possible with hash input/output, or if I just interlink multiple tmaps (one tmap for varA, then another for varB), but was wondering if at all it was possible in a single component.
I've taken a couple of screenshots and posted them in a powerpoint
Would be really, really grateful if anyone could help me sort this out. Thanks!