6 Replies Latest reply: May 10, 2016 2:57 AM by Tal Sibony RSS

    Qlik Sense - Using Smart Data Load:

    Tal Sibony

      Hi,

       

      After watching the video below which shortly explains the association defining, I have encountered a problem with defining artificially the 2 columns association when the correct association doesn't appear in the recommendations..

       

      https://www.youtube.com/watch?v=f8gBUbaPVcQ

       

      Thanx,

      Tal

        • Re: Qlik Sense - Using Smart Data Load:
          Michael Tarallo

          Hi Tal,

           

          Can you provide steps and example with screen shot. I am having trouble understanding what you mean by "defining artificially the 2 columns association"


          Do you mean you want o break the current automatic association and select the recommended association? And in your list of recommended associations, perhaps you don't see it in the list provided?  If that is the case, I am aware of a behavior where if the % match is low of the matching column, it might not display. If the column is the same name in the two data sources, use the Load Data and Finish button instead of prepare data.


          Check this video out:


          Parts 1 and 2: Qlik Sense 3.0 - Preparing Data with Visual Data Preparation

           

          Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

           

          Regards,

          Mike Tarallo

          Qlik

            • Re: Qlik Sense - Using Smart Data Load:
              Tal Sibony

              Hi Michael,

               

              The case I am describing is when non of the recommended associations is the correct 1.

              then, I am interested in defining by myself the right connection.

               

              For instance, please look at the picture below:

              Because I am familiar with the tables 'publisher' and 'campaign', the right connection suppose to based only on 'pb_id' column, without 'capping_percent' column.

              As you can see, there isn't recommendation for this association.

              How can I set this association anyway? Is there an option to set it manually?

              (*this what I meant by "defining artificially" - without using the available existing recommendations)

               

              Thank you very much!

               

              Association.PNG

                • Re: Qlik Sense - Using Smart Data Load:
                  Michael Tarallo

                  Hi Tal - ah I thought so but was not sure - this is exactly what I feared when I stated this:

                   

                  "If that is the case, I am aware of a behavior where if the % match is low of the matching column, it might not display. If the column is the same name in the two data sources, use the Load Data and Finish button instead of prepare data."


                  In order to fix this manually, you will need to go into the Data Load Editor and manually rename the column using the AS keyword and give your column name the same name Alias as the one you want it to associate on:


                  Such as:


                  [Orders$]:

                  LOAD

                      [OrderID] AS [OrderID],

                      [OrderDate] AS [OrderDate],

                      [CustomerID] AS [CustomerID],

                      [EmployeeID] AS [EmployeeID],

                      [ShipperID] AS [ShipperID],

                      [ProductID] AS [ProductID],

                      [Sales] AS [Sales],

                      [COS] AS [COS],

                      [GP] AS [GP],

                      [Quantity] AS [Quantity],

                      [Discount] AS [Discount],

                  ....

                  ....

                  ...

                  [Customers]:

                  LOAD

                      [Address] AS [Address],

                      [City] AS [City],

                      [ContactName] AS [ContactName],

                      [Country] AS [Country],

                      [CustomerName] AS [CustomerName],

                      [CustomerNumber] AS [CustomerID],

                  ...

                  ...

                  ...

                   

                   

                  Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

                   

                  Regards,

                  Mike Tarallo

                  Qlik

                    • Re: Qlik Sense - Using Smart Data Load:
                      Tal Sibony

                      Hi Michael,

                       

                      I'm not really satisfied of the solution since it forces me to change my original data (column name), but as I understand, it is the only way to influence on the prepare data association recommendations..

                       

                      I would expect to have much comfortable feature to assist me to define the correct association without corrupting my data.

                       

                      In my case, I would need to change the name of 'capping_percent' column in 1 of the tables in order it wont be automatically recognized as association between the 2 tables.

                       

                      Still, it doesn't take any of your will to assist me - thank you very much for your help!

                       

                      Tal Sibony