Not really sure what you are trying to achieve. Some sample lines of data and expected result may help to understand.
These tables link on fieldname1:
LOAD *, 1 AS countfields INLINE [
fieldname1, fieldname2, fieldname3
UNQUALIFY fieldname1 ;
LOAD fieldname2 as fieldname1, fieldname3, 1 AS countfields INLINE [
LOAD fieldname2, fieldname3 as fieldname1, 1 AS countfields INLINE [
swuehl im trying to join three tables loaded via sql and qualify two of the tables apart from the single field from all three that will be the join.
I have to also rename the field though and I can only seem to rename in one of the table loads?