This content has been marked as final. Show 3 replies
You must have field in database , which associates Field1 with Field2.
You can do like this, but it doesn't make sense (for examle Paris concatenate with Spain):
Countries: LOAD * INLINE [ Country,values1 USA,60 Spain,70 Italy,65 France,68 ]; Cities: LOAD * INLINE [ City,values2 New York,5 Madrid,3 Milan,3 Paris,7 ]; TempTableOuterJoin: LOAD Country Resident Countries; JOIN(TempTableOuterJoin) LOAD City Resident Cities; NoConcatenate TableOuterJoin: LOAD City & '_' & Country, Country, City Resident TempTableOuterJoin; DROP TABLE TempTableOuterJoin;