18 Replies Latest reply: Sep 4, 2017 3:41 AM by fredrik olsson RSS

    Synthetics keys

    fredrik olsson

      Hi,

       

      My app "complain" about use of synthetics keys during the data load process.

      Is this possible to solve in a better way and avoid synthetics keys warning? I wanna be able to compare the Reservation data with the Search data and drill down based on geographic's and Supplier. Any help are very appreciated!

       

      Reservation:

      LOAD

      ReservationId,

      Name,

      ReservationDate,

      TotalPrice,

      Supplier,

      DestinationCityName;

       

      Search:

      LOAD

      SearchId,

      SearchDate,

      Date1,

      Date2,

      Supplier,

      DestinationCityName;

       

      DestinationGEO:

      LOAD

          CityName as DestinationCityName,

          CountryCode as DestinationCountryCode,

          CountryName as DestinationCountryName,

          ContinentCode as DestinationContinentCode,

          ContinentName as DestinationContinentName

      FROM [lib://Statistics Export Folder/geo.csv]

       

      Message was edited by: fredrik olsson