9 Replies Latest reply: Sep 19, 2018 11:59 AM by zhen pan RSS

    How to load the data?

    drishti goel

      Hello All,

       

      I have an requirement wherein I need to store the data as: I have attached the xls sheet.

       

      Output:

       

      Date     Profit Specialist     Manager      Alerts     Sales        qlr     received     totalof quotes

      01/08     A                              B                   1          2             3          4                      5

                                                     C                   6          7            8          9                    10                   

                     D                             E                   11     12            13         14                    15

                                                     F                    6          7            8          9                    10          

                                                     G                    6          7            8          9                    10          


      02/08  ...........................................................................................................................



      Any lead will highly be appreciated.

       

       

      Thanks and Regards,

      Drishti Goel

        • Re: How to load the data?
          Petter Skjolden

          Just to be clear - you haven't attached an xls sheet. You have attached an xlsx workbook containing three sheets named Sheet1, Sheet2 and Sheet3.

           

          The Excel workbook opens at Sheet2 but Sheet1 also have similar data but structured differently. Which one of the sheets do you want to be used as basis for the Qlik application?

            • Re: How to load the data?
              drishti goel

              HI Peter,

               

              Sorry, for not uploading the data correctly. It is the Sheet 2 which we need to refer.

              Output:

               

              Output:

               

              Date     Profit Specialist     Manager      Alerts     Sales        qlr     received     totalof quotes

              01/08     A                              B                   1          2             3          4                      5

                                                             C                   6          7            8          9                    10                   

                             D                             E                   11     12            13         14                    15

                                                             F                    6          7            8          9                    10          

                                                             G                    6          7            8          9                    10          


              02/08  ...........................................................................................................................

               

               

              Basically we trying to tweak PS and Manager rows into column and merging all 18 different columns into 5 category.

            • Re: How to load the data?
              Rahul Thakkar

              TO load data you can find details at Qlik help - https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/DataSource/load-data-from-Excel.htm

               

              Attached excel looks like an report in itself. You will have to identify what you information you require to reach to output and perform the cleanup / tranformations.

               

              Regards,

              Rahul

              • Re: How to load the data?
                shivesh singh

                Hi

                 

                Which sheet do you want to upload in Sense? What's the logic for your output?

                 

                Thanks

                  • Re: How to load the data?
                    drishti goel

                    I apologize for not uploading it correctly. It is Sheet 2.

                     

                    Desired Output;

                     

                    Output:

                     

                    Date     Profit Specialist     Manager      Alerts     Sales        qlr     received     totalof quotes

                    01/08     A                              B                   1          2             3          4                     5

                                                                   C                   6          7            8          9                    10                   

                                   D                             E                   11       12           13        14                   15

                                                                   F                    6          7            8          9                    10          

                                                                   G                    6          7            8          9                    10          


                    02/08  ...........................................................................................................................

                     

                      • Re: How to load the data?
                        sujeet singh

                        Can you give a sample app.

                          • Re: How to load the data?
                            drishti goel

                            I have attached the xls workbook. We need to refer sheet 2. that is we are tweaking Profit Specialist and Manager rows into column and then trying to join all the  other 17 columns into  5 different column

                             

                            output:

                            Date     Profit Specialist     Manager      Alerts     Sales        qlr     received     totalof quotes

                            01/08     A                              B                   1          2             3          4                     5

                                                                           C                   6          7            8          9                    10                   

                                           D                             E                   11       12           13        14                   15

                                                                           F                    6          7            8          9                    10          

                                                                           G                    6          7            8          9                    10    

                      • Re: How to load the data?
                        zhen pan

                        are you using Qlik Sense?

                        Have you tried

                        Generic SELECT* from YourTable;


                        see help below

                        https://help.qlik.com/en-US/sense/November2017/Subsystems/Hub/Content/DataSource/generic-databases.htm