I have the following task:
I have a single xml file containing multiple product IDs and a single buyer ID. I need to enrich the file with prices, which I get with a SQL query including the buyer ID (prices are different depending on the buyers conditions).
My "solution" so far:
I tried to create two tables. One containing all product IDs in the xml file (tLogRow_1) and the other one is the result of the SQL query containing all product IDs the buyer is able to buy and their prices (tLogRow_3, lookup).
I can't put both streams into a single tMap component (since its the same stream I guess). How can I achieve this without saving everything within temp files?
Thanks in advance for the help
Solved! Go to Solution.
Thanks for the fast reply. The hash components were hidden per default but after activating them in the project settings everything seems to work perfectly.