8 Replies Latest reply: Jun 27, 2018 9:51 AM by Pascal Dijkshoorn RSS

    New calculated field from 2 different tables in script

    Pascal Dijkshoorn

      Hello everyone,

       

      I want to add a new calculated field in the script from 2 tables that are linked with the 'main' table. This is the current situation in my script:

       

      Main Table:

      ShipmentNumber

      Load_Location

      Unload_Location

       

      ExcelFileLoad

      Load_Location

      Load_Location_New

       

      ExcelFileUnload

      Unload_Location

      Uload_Location_New

       

      The Excel files are created to get the correct load/unload locations into Qlik. I want to create a new calculated field with the following formula: "Load_Location_New"&'-'&"Unload_Location_New" as Shipment_Lane.

       

      How could I fix this?