I am seeking a method to merge table outputs from ZonalHistogram (ZH) using a Python script. These files have a simple two-column format. E.g., AAA.dbf has two fields: * LABEL - the X-axis with values ranging from 0 to 100 * AAA - the Y-axis counts produced by ZH Similarly, BBB.dbf has two fields, LABEL and BBB, CCC.dbf has LABEL and CCC. I am able to plot these individual table files with arcpy graph, or render them in Excel. I am trying to merge these files into a single output with the structure: LABEL AAA BBB CCC 0 - 100 ZH values ZH values ZH values I started simply with: tablesList = arcpy . ListTables ( ) arcpy . Merge_management ( tablesList , "merged.dbf" ) which gave me the four columns I was after but the output was arranged as: rows 0 - 100: LABEL (0 - 100) ZH values 0 0 rows 101 - 201: LABEL (0 - 100) 0 ZH values 0 rows 202 - 302: Label (0 - 100) 0 0 ZH values I have attempted to use field mapping as follows: import arcpy TESTDIR = some dir > arcpy . env . workspace = TESTDIR arcpy . env . scratchWorkspace = TESTDIR arcpy . env . overwriteOutput = True tablesList = arcpy . ListTables ( ) inFields = [ u 'LABEL' , u 'AAA' , u 'BBB' , u 'CCC' ] # Generated by arcpy.Describe() fieldMappings = arcpy . FieldMappings ( ) # Deal with "LABEL" as special case (first field of first table) fMap = arcpy . FieldMap ( ) fMap . addInputField ( tablesList [ 0 ] , inFields [ 0 ] ) outField = fMap . outputField outField . name = inFields [ 0 ] fMap . outputField = outField fieldMappings . addFieldMap ( fMap ) # Add the second field of each file to the map for i in range ( len ( tablesList ) ) : fMap = arcpy . FieldMap ( ) fMap . addInputField ( tablesList [ i ] , inFields [ i + 1 ] ) outField = fMap . outputField outField . name = inFields [ i + 1 ] fMap . outputField = outField fieldMappings . addFieldMap ( fMap ) arcpy . Merge_management ( tablesList , "merged.dbf" , fieldMappings ) The output was the same. It seems I have merely replicated the built-in Merge_management. I would be most grateful for any advice on modifying the script to generate the merged output I am after.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Seeking help with arcpy.Merge_management

IanMCDONALD

I am seeking a method to merge table outputs from ZonalHistogram (ZH) using a Python script. These files have a simple two-column format. E.g., AAA.dbf has two fields:

LABEL - the X-axis with values ranging from 0 to 100
AAA - the Y-axis counts produced by ZH

Similarly, BBB.dbf has two fields, LABEL and BBB, CCC.dbf has LABEL and CCC. I am able to plot these individual table files with arcpy graph, or render them in Excel.

I am trying to merge these files into a single output with the structure:
LABEL AAA BBB CCC
0 - 100 ZH values ZH values ZH values

I started simply with:

tablesList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListTables<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Merge_management<SPAN class="punctuation token">(</SPAN>tablesList<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"merged.dbf"</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

which gave me the four columns I was after but the output was arranged as:

rows 0 - 100:        LABEL (0 - 100)    ZH values        0                   0
rows 101 - 201:    LABEL (0 - 100)    0                      ZH values     0
rows 202 - 302:    Label (0 - 100)       0                      0                   ZH values

I have attempted to use field mapping as follows:

<SPAN class="keyword token">import</SPAN> arcpy
TESTDIR <SPAN class="operator token">=</SPAN> <SPAN class="operator token"><</SPAN>some dir<SPAN class="operator token">></SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> TESTDIR
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>scratchWorkspace <SPAN class="operator token">=</SPAN> TESTDIR
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

tablesList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListTables<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
inFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>u<SPAN class="string token">'LABEL'</SPAN><SPAN class="punctuation token">,</SPAN> u<SPAN class="string token">'AAA'</SPAN><SPAN class="punctuation token">,</SPAN> u<SPAN class="string token">'BBB'</SPAN><SPAN class="punctuation token">,</SPAN> u<SPAN class="string token">'CCC'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># Generated by arcpy.Describe()</SPAN>
fieldMappings <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>FieldMappings<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

 <SPAN class="comment token"># Deal with "LABEL" as special case (first field of first table)</SPAN>
fMap <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>FieldMap<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
fMap<SPAN class="punctuation token">.</SPAN>addInputField<SPAN class="punctuation token">(</SPAN>tablesList<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> inFields<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
outField <SPAN class="operator token">=</SPAN> fMap<SPAN class="punctuation token">.</SPAN>outputField
outField<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">=</SPAN> inFields<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
fMap<SPAN class="punctuation token">.</SPAN>outputField <SPAN class="operator token">=</SPAN> outField
fieldMappings<SPAN class="punctuation token">.</SPAN>addFieldMap<SPAN class="punctuation token">(</SPAN>fMap<SPAN class="punctuation token">)</SPAN>

 <SPAN class="comment token"># Add the second field of each file to the map</SPAN>
<SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN>len<SPAN class="punctuation token">(</SPAN>tablesList<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 fMap <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>FieldMap<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
 fMap<SPAN class="punctuation token">.</SPAN>addInputField<SPAN class="punctuation token">(</SPAN>tablesList<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> inFields<SPAN class="punctuation token">[</SPAN>i <SPAN class="operator token">+</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
 outField <SPAN class="operator token">=</SPAN> fMap<SPAN class="punctuation token">.</SPAN>outputField
 outField<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">=</SPAN> inFields<SPAN class="punctuation token">[</SPAN>i <SPAN class="operator token">+</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
 fMap<SPAN class="punctuation token">.</SPAN>outputField <SPAN class="operator token">=</SPAN> outField
 fieldMappings<SPAN class="punctuation token">.</SPAN>addFieldMap<SPAN class="punctuation token">(</SPAN>fMap<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Merge_management<SPAN class="punctuation token">(</SPAN>tablesList<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"merged.dbf"</SPAN><SPAN class="punctuation token">,</SPAN> fieldMappings<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The output was the same. It seems I have merely replicated the built-in Merge_management. I would be most grateful for any advice on modifying the script to generate the merged output I am after.

Trouver plus de publications taguées avec

Accepted answers

curtvprice

I see when the TableToTable conversion is complete, the dbf has had its field names mangled with trailing "_" and digits and restricting them to 10 character

The 10 character truncation is because you your output is in shapefile or .dbf format. If you output to a geodatabase your field names will not be mangled to fit in the 10 character limit. The field names changes are those that are required to make the field name valid for the output format see the ValidateFieldName method in the help for more on that.

You may have better luck if you set the environment arcpy.env.qualifiedFieldNames to False, this will prevent your merge from trying to include the prefix in the output name. (When I think about it, this may be your main issue.)

All comments

IanMCDONALD

I have run this too and it works well. I found it a most instructive alternative to the join approach. Thank you

IanMCDONALD

Thanks very much for this contribution, Randy. I'll do some work with it over the weekend.

RandyBurton

While it is good to know something about field mappings, they can be annoying to work with. And there are alternatives. Here's some code I was testing that might be of interest.

It starts by making a copy of the first dbf file. Then lines 14-21 checks for the specific field of interest, and if found, creates an identical type in the dbf copy. After creating the field, the script loads the second dbf's data of interest into a dictionary. An update cursor uses the dictionary to populate the newly created field. Note this is assuming there is a 1:1 match on the LABEL field.

As script was just a quick test, some additional error checking may be necessary.

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> sys

<SPAN class="comment token"># make a copy of the first dbf file</SPAN>
dbfAAA <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\test\dbf\AAA.dbf"</SPAN> <SPAN class="comment token"># this is the first dbf</SPAN>
dbfOUT <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\test\dbf\OUT.dbf"</SPAN> <SPAN class="comment token"># this is the copy fields will be added to</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Copy_management<SPAN class="punctuation token">(</SPAN>dbfAAA<SPAN class="punctuation token">,</SPAN> dbfOUT<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># this is the dbf containing the field we want</SPAN>
dbfBBB <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\test\dbf\BBB.dbf"</SPAN>
fldsBBB <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'LABEL'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'BBB'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># fields for our dictionary, the second one is the one we need to copy</SPAN>

<SPAN class="comment token"># get the field's information and add the same type of field to our copy dbf file</SPAN>
<SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>dbfBBB<SPAN class="punctuation token">,</SPAN>fldsBBB<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">if</SPAN> field<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> None<SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># add field, (assuming all these properties are available)</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>dbfOUT<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>type<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>precision<SPAN class="punctuation token">,</SPAN>
                                  field<SPAN class="punctuation token">.</SPAN>scale<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>length<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>aliasName<SPAN class="punctuation token">,</SPAN>
                                  field<SPAN class="punctuation token">.</SPAN>isNullable<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>required<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>domain<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"ERROR: field {} not found"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>fldsBBB<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
        sys<SPAN class="punctuation token">.</SPAN>exit<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># exit on error, may want to recode for more graceful exit</SPAN>

<SPAN class="comment token"># read second dbf file into a dictionary</SPAN>
dicBBB <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> r <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>dbfBBB<SPAN class="punctuation token">,</SPAN> fldsBBB<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token"># use update cursor to add the data to the dbf copy</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>dbfOUT<SPAN class="punctuation token">,</SPAN>fldsBBB<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
        row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> dicBBB<SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
        cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Regarding field mappings, here is an old article from ArcUser that might be helpful:

Use Field Mapping and Python Scripting to Make Your Job Easier PDF version

curtvprice

I would print field in the loop so you can figure which one failed.

IanMCDONALD

Hi All,

I'm having a go at both approaches. I need to gain some experience with field mappings, so ...

After the join, tbl1 has the fieldnames:

[u'AAA.OID', u'AAA.LABEL', u'AAA.AAA', u'BBB.OID', u'BBB.LABEL', u'BBB.BBB', u'CCC.OID', u'CCC.LABEL', u'CCC.CCC']

I determine which of these I want to keep for the TableToTable_conversion with:

keepFields = [u'AAA.OID', u'AAA.LABEL', u'AAA.AAA', u'BBB.BBB', u'CCC.CCC']

and attempt to build the fieldMappings with:

fieldMappings <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>FieldMappings<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> fieldnames<SPAN class="punctuation token">:</SPAN>
 fMap <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>FieldMap<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="keyword token">if</SPAN> field <SPAN class="keyword token">in</SPAN> keepFields<SPAN class="punctuation token">:</SPAN>
  fMap<SPAN class="punctuation token">.</SPAN>addInputField<SPAN class="punctuation token">(</SPAN>tbl1<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">)</SPAN>
  outField <SPAN class="operator token">=</SPAN> fMap<SPAN class="punctuation token">.</SPAN>outputField
  outField<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">=</SPAN> field
  fMap<SPAN class="punctuation token">.</SPAN>outputField <SPAN class="operator token">=</SPAN> outField
 fieldMappings<SPAN class="punctuation token">.</SPAN>addFieldMap<SPAN class="punctuation token">(</SPAN>fMap<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

which produces the error:

RuntimeError: FieldMap: Error in adding input field to field map

for line 5.

Can you suggest how I might follow this up? My limited experience can find no help in the error message at all!

Ian

DanPatterson_Retired

When you do explore the join options check your data for singularities of the Label field otherwise you may have to deal with an additional 'summarize' as I indicated. If they are singular then either of the 'join' options would make things a lot easier for you

IanMCDONALD

Thank you Dan, Randy and Curtis. I am most grateful for your ideas. I am unable to follow up on them this evening but I will let you know how I get on.

curtvprice

Or, Add Join tables 2 and 3 to table 1 and copy the table view with Table to Table. This method has a nice advantage in that you can use a field map to control the order and names of the output fields.

RandyBurton

It looks as if you want to join tables, not merge them. See Add Join for more information. You would join on the LABEL field.

An alternative to the join is to read the dbf files into dictionaries using a SearchCursor, combining them and saving the results. An example:

import arcpy

dbf = r"C:\path\to\dbf\AAA.dbf"
flds = ['LABEL', 'AAA']
dic1 = {r[0]: r[1] for r in arcpy.da.SearchCursor(dbf, flds)} 

dbf = r"C:\path\to\dbf\BBB.dbf"
flds = ['LABEL', 'BBB']
dic2 = {r[0]: r[1]&nbsp; for r in arcpy.da.SearchCursor(dbf, flds)}

dbf = r"C:\path\to\dbf\CCC.dbf"
flds = ['LABEL', 'CCC']
dic3 = {r[0]: r[1]&nbsp; for r in arcpy.da.SearchCursor(dbf, flds)}

print "LABEL\tAAA\tBBB\tCCC"
for k, v in dic1.iteritems():
&nbsp;&nbsp;&nbsp; print "{}\t{}\t{}\t{}".format(k, v, dic2<K>, dic3<K>)

# would give something like:
'''
LABEL	AAA	BBB	CCC
0	100	200	300
1	101	201	301
2	102	202	302
3	103	203	303
4	104	204	304
'''‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></K></K>

DanPatterson_Retired

LABEL AAA BBB CCC
0 - 100 ZH values ZH values ZH values

This suggests to me a join on the LABEL field. But is there a many to one, one to one etc.

Maybe if you have a larger sample to show, it might help.

Join with a summarize? hard to tell

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.