Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community,
I have three different sheets:
Sheet 1: Customerinformation
Customer ID | Customername | Country |
---|---|---|
100001 | Johnny Fish Market | Japan |
100002 | Beef Steak Club | USA |
100003 | Fruit Passion | Spain |
100004 | Vegiland | Germany |
Sheet 2: Invoiceinformation
CustomerID | Customername | Product | Invoice | Year |
---|---|---|---|---|
100001 | Johnny Fish Market | Salmon | 1000 | 2013 |
100002 | Beef Steak Club | Beef | 2000 | 2013 |
100003 | Fruit Passion | Banana | 3000 | 2013 |
100004 | Vegiland | Tofu | 4000 | 2013 |
100001 | Johnny Fish Market | Tuna | 2000 | 2014 |
100002 | Beef Steak Club | Porc | 3000 | 2014 |
100001 | Johnny Fish Market | Octopus | 1000 | 2015 |
100004 | Vegiland | Soja | 2000 | 2015 |
100001 | Johnny Fish Market | Seatongue | 3000 | 2016 |
Sheet 3: Transportinformation
CustomerID | Customername | Transportagency | Location |
---|---|---|---|
100001 | Johnny Fish Market | Shipping Ltd | Tokyo |
100002 | Beef Steak Club | Meat Transport Ltd | New York |
100003 | Fruit Passion | Fruit Shuttle Ltd | Barceolona |
100004 | Vegiland | Vegi Transport Ltd | Berlin |
What I want is to create a view. if I create a Listbox with Customername and choose Johnny Fish Market. It should give me out in a diagram:
Customername | Country | Product | Invoice | Year | Transportagency |
---|---|---|---|---|---|
Johnny Fish Market | Japan | Salmon | 1000 | 2013 | Shipping Ltd |
Johnny Fish Market | Japan | Tuna | 2000 | 2014 | Shipping Ltd |
Johnny Fish Market | Japan | Octopus | 1000 | 2015 | Shipping Ltd |
Johnny Fish Market | Japan | Seatongue | 3000 | 2016 | Shipping Ltd |
I know that I have to configure the script and read sth about the Mapping function. I am a beginner andI dont really know how to do it. Could anyone help me here?
I attached an Excel file.
See this blog post: Don't join - use Applymap instead
All you have to do is load the data, create a table box with the fields you want to see and select Johny Fish Market. See attached qvw.
yeah i figured out, i thought i had to do sth like INNERJOIN like in Access. But could you explain me what the mapping function is. Maybe with an example.
See this blog post: Don't join - use Applymap instead