I am new to Talend, still getting to learn the basics of tMap and tJoin. However, i am finding it hard to create a job design as visualized in my attachment. Could someone please help sketch a workable flow for this?
The data found on all the 4 tables at the start are totally not related except for the fact that some columns may match for example the GDP column in Canada and Nigeria Tables. Thats why i said my work flow may not be as required but my main goal is to get the first 4 tables to look like the arrangement in the last table. Thanks. Feel free to ask for more clarification. I have not used the surrogate function as you have suggested but i will give it a try
