4 Replies Latest reply: Feb 26, 2016 9:49 AM by Muliady Hartono RSS

    Data linkage in data model

    Hemang Dave

      Hi

       

      I've downloaded qliksense desktop and 've started building data model for an app.

       

      After loading data from a bunch of .csv files (each .csv file represents a table), Qliksense suggested certain data links which was helpful, however there are other data linkages that needs to be made that are not suggested by Qliksense's association functionality.

       

      Following is a picture of the data model. Please guide as to how to create data associations (linkages) outside of the once suggested by association?

       

      Sales_vs_target_data_model.PNG

      Notice some of the islands above. They need to be associated/linked to one of the tables. Please help.

       

      Thanks

        • Re: Data linkage in data model
          balraj ahlawat

          First , identify &..analyze each and every table

           

          Is their any common & unique data is avail in between tables??

           

          If yes, then alias that field and make the same name as in another table to like it, like

           

          TableA:

          Load

          *,

          ID

          From TableA;

           

          TableB:

          load

          *

          Number as ID

          from TableB;

          • Re: Data linkage in data model
            jagan mohan rao appala

            Hi,

             

            Qliksense will join tables based on the column names.  Sometimes the column names may not be same, so we have to manually rename the columns to make join happen.

             

            For example:

             

            Product_Sales:

            LOAD

            Product_Sales.account_id AS account_id

            '

            '

            '

            FROM DataSource;

             

            Account:

            LOAD

            account_id,

            '

            '

            FROM DataSource2;

             

            Now this two tables are joined using account_id column.

             

            Hope this helps you.

             

            Regards,

            jagan.

              • Re: Data linkage in data model
                Hemang Dave

                Thanks for the revert.

                 

                While trying to edit the script this is what is noticed.

                 

                Since i had used the add data wizard to load data, Qliksense has auto-generated a script in a separate tab (different from main) and it is read only. i.e. it doesn't allow editing Or even copying the script.

                 

                autogenerated script.PNG

                  • Re: Data linkage in data model
                    Muliady Hartono

                    You can also rename the fields by going to the "Data Manager" section on the left navigation. When the field names match, the tables will be automatically associated with each other.

                     

                    Data Manager.PNG

                    Then on the table you want to edit, click the "pencil" button.

                     

                    edit.PNG

                     

                    Then click on the field header, and just make it the same name as the other field in the other table that you want to link.

                     

                    Then load the data again.

                     

                    I hope this helps.

                     

                    Regards,

                    Muliady