Hi,
i was now searching and trying for some time and was not able to find a solution for an obviously simple problem. I want to perform an vLookup like mapping in talend.
This is what i have so far:
Master File:
uid
name
description
....
Lookup File:
parentUID(refers to UID in Master file)
attributeID
value
Target File
"ID": master.uid
"Name: master.name
"Description": master.description
"Image": lookup.value (link via lookup.parentUID and master.UID and filter for an specific attributeID like "2388")
"TDS": lookup.value (link via lookup.parentUID and master.UID and filter for an specific attributeID like "2547")
"PDS": lookup.value (link via lookup.parentUID and master.UID and filter for an specific attributeID like "157")
I assume for someone who's familiar with talend this is a dummy question but as i learn talend by doing and try an error and never had this usecase befor i have no clue on what to do after trying/searching for 6 hours.
