Network Map

Hi!

I need to build a network distribution map (example attached). I have an excel file with stores and another for all the distribution centers that serve the stores. The idea is to map all the distribution centers with their corresponding stores in a map. I've tried a couple of things found on the forum but with no luck.

Any help would be greatly appreciated!

Network map.png

Reporting

Tips and Tricks

Help

Accepted answers

Jonathan-Sherman

Hi @Fco_Garcia,

You could also output the map to a PDF for example with the use of report map and render tools:

Which could generate you a PDF like this (also attached):

If this solves your issue please mark the answer as correct, if not let me know! I've attached an updated workflow for you to download if needed.

Regards,

Jonathan

20200324 - MappingNetworks v2.yxmd

ReportMap.pdf

All comments

CharlieS

Hi @Fco_Garcia

This is very possible in Alteryx! I have a few questions to start with to make sure we have the data we need:

- Do you have spatial data on the location of each distribution center and store? This could be latitude/longitude values, or spatial objects like centroids or polygons?

- Can you Join your distribution and store lists together?

- Could you share some screenshots of your data so we know what your fields look like?

I'm sure the Community can help you, we just need to know where we begin.

Fco_Garcia

Hi Charlie!

To answer your questions:

- I have addresses, but can get the latitude/longitude values from it

- Yes I can join both together - right now the lists are connected by the distribution center(s) that serves that store

* Store list example:

DC	Country	City	Full address
DC1	COUNTRY 1	CITY 1	XXX STREET
DC2	COUNTRY 1	CITY 2	YYY STREET

* Distribution center list:

DC	DC Country	DC City	DC address line	DC postcode
DC1	COUNTRY 1	CITY 1 & CITY 2	XYX STREET	111 111

* Important to consider that store can be served by more than 1 DC

Thanks!

Jonathan-Sherman

Hi @Fco_Garcia,

You could also output the map to a PDF for example with the use of report map and render tools:

Which could generate you a PDF like this (also attached):

If this solves your issue please mark the answer as correct, if not let me know! I've attached an updated workflow for you to download if needed.

Regards,

Jonathan

20200324 - MappingNetworks v2.yxmd

ReportMap.pdf

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335