14 Replies Latest reply: Aug 17, 2010 10:01 AM by Chris Hopkins RSS

    Joining 2 fields from 2 different tables

    Chris Hopkins

      Hi, i need some help joining 2 fields from different tables.

      My tables are as follows

      LOAD

      StoreNumber,

      TransId,

      EmployeeId

      FROM

      C:\QLIKVIEW\Transaction.csv

       

      LOAD

      StoreNumber,

      EmployeeName

      FROM

      C:\QLIKVIEW\Employee.csv

       

      I want to create a new field called STOREEMPLOYEE from EmployeeId (from the first table) and EmployeeName (From the second table)

      Can anyone tell me how to do thsi please?