10 Replies Latest reply: Feb 5, 2015 2:06 PM by Rob Wunderlich RSS

    Joined Table Shows up with records split within table (and other) objects

    Jeff Lancaster


      I'm hoping someone can see what I am missing here.  For some reason I'm having an issue with one table.

       

      I have joined two tables using a key field and to simplify (and for troubleshooting purposes) have removed all but one additional field in each table and have removed all other tables.  The script runs fine and when complete I can preview my table (Ctrl-T), which appears to be in good working order.  (See below.)

      Capture3.PNG

      Capture.PNG

      As you can see, there are values in both of the non-key fields in each record, making it seem that the two tables were joined successfully (cleanly) and correctly.  This looks good to me.

       

      But when trying to view this information in a simple Table object, the rows are split, where the "Regular_Hours_Init" and "Regular_Expense_Init" field values show up on different rows, with the same key field for each, as shown below.

      Capture2.PNG

      I have never had this problem before and cannot figure out what is causing this to occur.  I assume that the underlying table within QlikView is correct, based on the 1st image, above, but am not sure why the records are showing up split in this manner.  It's almost like the two original tables are being concatenated instead of being joined.  Is there a table/object/document or other setting that is causing this behavior?  It only seems to be occuring with this table for me.

       

      The script in place is below.  It executes with no errors.

       

      OA_Payroll_Input_File_Init:
      LOAD
      date(date#([End Date],'MMDDYYYY'),'YYYYMMDD') & [Where Worked] & right([Job Code],5) & Right('0000'&[Employee ID],5) as Table_Link_Init,
      Num(DLLRS,'0.00') as Regular_Expense_Init
      FROM
      [\\<servername>\FinancialPrivate\Data\Finance-Secure\Transfer\to BRAIN\Payroll - BiWeekly\Biweekly Dllrs*.XLS]
      (
      biff, embedded labels, header is 5 lines, table is [BiWkly Dllrs$])
      Where Not IsNull([Where Worked]);

      Join (OA_Payroll_Input_File_Init)
      LOAD
      date(date#([End Date],'MMDDYYYY'),'YYYYMMDD') & [Where Worked] & right([Job Code],5) & Right('0000'&[Employee ID],5) as Table_Link_Init,
      Num(HOURS,'0.0') as Regular_Hours_Init
      FROM
      [\\<servername>\FinancialPrivate\Data\Finance-Secure\Transfer\to BRAIN\Payroll - BiWeekly\Biweekly Hrs*.XLS]
      (
      biff, embedded labels, header is 5 lines, table is [BiWkly Hrs$])
      Where Not IsNull([Where Worked]);

       

       

      If anyone has any suggestions for me on this, I would greatly appreciate it.  It could be something simple that I am just overlooking...

       

      Thank you all.