The Equipment and Equipment Attribute columns are combined into one, as shown by the screenshot below. I’ve given the new column the name Equipment then we can click OK. Select the Equipment and Equipment Attribute columns, then click Transform > Merge Columnsįor our example, we want to place a colon and space between the two columns. So, we need to select –Custom– from the Separator drop-down list, and in the box below, enter Colon ( : ), followed by a space character. Initially, we will combine Equipment and Equipment Attribute into a single column, then combine the rows into a single row for each employee. Now we’re ready to start the transformations. The Power Query window opens and displays the data from the Table. Select a cell within the data table, then click Data > From Table / Range. This all sounds simple, doesn’t it? Before Power Query, we would need to use complex formulas to achieve this result. But with Power Query, it becomes a few simple transformations.

The goal is to combine all equipment information for each employee into a single cell (as shown below).

reset ( ) for row in cur : pass ‍ ‍ ‍ ‍ ‍ ‍ ‍Īlso, instantiating a cursor within a Python for loop is a performance killer, especially with more than a handful of items in the loop.In the screenshot, we have a list of employees and any equipment the company has allocated to them. For example, we can see Anna Watkins has a laptop, access card, phone, and home printer. SearchCursor (fc, fields ) as cur : for row in cur : passĬur.

When iterating over a data set numerous times using the same cursor arguments, it is more efficient to create the cursor once and reset it than recreate it each time. Page_names += page if page_names = '' else delim + page ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍Ī couple of thoughts on your code snippet. SearchCursor (fc, ) as cur : for street, page in cur : Page_names = defaultdict (str ) with arcpy. faultdict - High-performance container datatypes - Python 2.7.17 documentation and 5.11 Conditional Expressions - Python 2.7.17 documentation , the dictionary can be generated with a single pass of the cursor: import arcpy

How to merge duplicate rows in excel