8 Replies Latest reply: Oct 8, 2015 11:32 AM by Stefan Wühl RSS

    Rename a field and Qualify ?

      I have three tables and im using qualify on both to rename the fields but unqulaifying one field that which i rename to be the join between all three tables.

       

      The problem is that two tables will join but I cant get the second table's field to rename!!  Ive tried rename field To , rename as within the load..

       

      How can I rename the field in the qualify of the second table so that all three tables will join ?

       

      QUALIFY *;

      UNQUALIFY fieldname1;

       

      Filteredtable1:

      SQL SELECT *,

       

      1 AS countfields

       

       

      FROM "ABC".dbo."Filteredtable1";

      UNQUALIFY *;

       

      QUALIFY *;

       

      UNQUALIFY fieldname2 ;

       

       

      Filteredtable2:

      SQL SELECT *,

       

      1 AS countfields

       

      FROM "ABC".dbo."Filteredtable2";

       

      UNQUALIFY *;

       

      Filteredtable3:

      SQL SELECT *,

       

      fieldname3 as fieldname1 , //// JOIN

      1 AS countfield

       

      FROM "ABC".dbo."Filteredtable3";