6 Replies Latest reply: Feb 9, 2017 9:34 AM by Nikos Karagiorgos RSS

    Multiple selections from excel

    Nikos Karagiorgos

      Hi,

      I have load data from excel that has Customer_Code,Customer_Name,Sales and make the following table:

       

      Customer_CodeCustomer_NameSales

      100

      A100

      200

      B50
      300C200

       

      My question is,

      if i load data from another excel that has only the customer code and customer name (e.g. Customer_Code 200-300,Customer_Name B-C)

      is it possible to make multiple selection from when i press a button only for the Customers of the second excel?

      thanks

        • Re: Multiple selections from excel
          Silambarasan Manickam

          Hi,

           

          Can you explain your question. Its not able to understand.

          or

          Share the screenshot how do u want to show your output.

          • Re: Multiple selections from excel
            Lakshmikandh Karthikeyan

            Yes, load both sheets with same column name for common columns

            • Re: Multiple selections from excel
              Philippe LABORDE

              Hi Nikos,

               

              If your question is how to load the both excel files in a single table, Lakshmikandh give you the solution: load both files with the same names of columns. It will concatenate automatically the data and you will have 3 columns containing the data of your 2 sources.

               

              If your question is how to filter these data by source (File1, File2), after their load, you can simply add a column called Source. You will fill it with 'File1' during your first excel file loading & 'File2' during the second one.

              You will obtain:

               

              Customer_CodeCustomer_NameSalesSource

              100

              A100File1

              200

              B50File1
              300C200File2

               

              Rdgs

              Philippe

              • Re: Multiple selections from excel
                Nikos Karagiorgos

                Sorry,

                I will try to explain with more details

                I have two excel files

                Fist named

                Sales   

                Customer_CodeCustomer_NameSales
                1A100
                2B500
                3C200
                4D450
                5E125
                6F456
                7G865
                8H234
                9I446
                10J134

                Second Customers

                  

                Customer_CodeCustomer_Name
                1A
                3C
                6F
                9

                I

                Load Data

                Sales:

                LOAD

                    Customer_Code,

                    Customer_Name as SalesCustomerName,

                    Sales

                FROM [lib://sales/sales.xlsx]

                (ooxml, embedded labels, table is Sheet1);

                 

                Customer:

                LOAD

                    Customer_Code,

                    Customer_Name as CusCustomerName

                FROM [lib://sales/Customers.xlsx]

                (ooxml, embedded labels, table is Sheet1);

                 

                Create a Table

                  

                Customer_CodeNameSales
                1A100
                2B500
                3C200
                4D450
                5E125
                6F456
                7G865
                8H234
                9I446
                10J134

                Now

                I want with a button to make multiple selection with values from the second excel

                  

                Customer_CodeNameSales
                1A100,00
                3C200,00
                6F456,00
                9I446,00

                thanks

                  • Re: Multiple selections from excel
                    Philippe LABORDE

                    Dear Nikos,

                     

                    As I tell you, you can add a column called 'source' to indicate where your data are coming from.

                     

                    Sales:

                    LOAD

                        Customer_Code,

                        Customer_Name as SalesCustomerName,

                        Sales,

                      'File1' as Source

                    FROM [lib://sales/sales.xlsx]

                    (ooxml, embedded labels, table is Sheet1);

                     

                    Customer:

                    LOAD

                        Customer_Code,

                        Customer_Name as CusCustomerName,

                        'File2' as Source

                    FROM [lib://sales/Customers.xlsx]

                    (ooxml, embedded labels, table is Sheet1);

                     

                    Then you will be able to filter your data on these 2 values.

                    Select File2 on a list containing sources in order to display only File2 content.

                     

                    Source

                    File1

                    File2 (select this value)

                     

                    Customer_CodeNameSales
                    1A100,00
                    3C200,00
                    6F456,00
                    9I446,00

                     

                    Rgds,

                    Philippe

                  • Re: Multiple selections from excel
                    Nikos Karagiorgos

                    Thanks all for your answers