Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Talend,
I have a scenario where i have to do a lookup to multiple sources using different lookup keys and it was throwing me an error stating "All lookup tables must have the same expressions, this expression does not exist in other lookup".
May i know what is causing this issue and that what is the workaround for this kind of scenario?
I have attached a snapshot for further clarifications.
hi fdenis,
thanks for the reply.
What was required is that i have 1 main table and 2 files and I have to do main table left join with file A, and main table left join with file B.
I tried to do all with using only 1 tmap but seems its failing since the keys of main table left join file A vs main table left join file B is different. and Getting the following error: "ALL LOOKUP TABLES MUST HAVE THE SAME EXPRESSIONS, THIS EXPRESSION DOES NOT EXIST IN OTHER LOOKUPS"
Does this mean multiple joining can only be done in a tmap only if the joining keys of main table to file A-B are the same?