Multiple selections from excel

[Anonymous]

Hi,

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

Customer_Code	Customer_Name	Sales
100	A	100
200	B	50
300	C	200

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

[Silambarasan1306]

Hi,

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

or

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

[lakshmikandh]

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

[#4]

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_Code	Customer_Name	Sales	Source
100	A	100	File1
200	B	50	File1
300	C	200	File2

Rdgs

Philippe

[Anonymous]

Sorry,

I will try to explain with more details

I have two excel files

Fist named

Sales   

Customer_Code	Customer_Name	Sales
1	A	100
2	B	500
3	C	200
4	D	450
5	E	125
6	F	456
7	G	865
8	H	234
9	I	446
10	J	134

Second Customers

Customer_Code	Customer_Name
1	A
3	C
6	F
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_Code	Name	Sales
1	A	100
2	B	500
3	C	200
4	D	450
5	E	125
6	F	456
7	G	865
8	H	234
9	I	446
10	J	134

Now

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

Customer_Code	Name	Sales
1	A	100,00
3	C	200,00
6	F	456,00
9	I	446,00

thanks

[#6 · Accepted solution]

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_Code	Name	Sales
1	A	100,00
3	C	200,00
6	F	456,00
9	I	446,00

Rgds,

Philippe

[Anonymous]

Thanks all for your answers