Skip to content

keyerror when using join #120

@sephib

Description

@sephib

Hi,
Working on the Rasham Hekdesh I've encountered a KeyError: 'שם הקדש' error.
When trying to join the two resources:
hekdeshGeneral.csv and hekdeshPropery.csv

from dataflows import Flow, load, dump_to_path, printer, join
Flow(
   load(hekdeshGeneral, name='hekdesh_general'),
   load(hekdeshProperty, name='hekdesh_property'),
   dump_to_path('hekdesh_general_property'),
    join(
        'hekdesh_general', ['מספר תיק'],  # Source resource
        'hekdesh_property', ['מספר תיק'], # Target resource
        mode='full-outer'   `
    ),
   printer(num_rows=1, tablefmt='html')
).process()[1]

Bellow is the full error stack

Details --------------------------------------------------------------------------- KeyError Traceback (most recent call last) in 48 mode='full-outer' # Don't add new fields, remove unmatched rows 49 ), ---> 50 printer(num_rows=1, tablefmt='html') 51 ).process()[1]

~/anaconda3/envs/dataflows/lib/python3.7/site-packages/dataflows/base/flow.py in process(self)
13
14 def process(self):
---> 15 return self._chain().process()
16
17 def datastream(self, ds=None):

~/anaconda3/envs/dataflows/lib/python3.7/site-packages/dataflows/base/datastream_processor.py in process(self)
84 try:
85 for res in ds.res_iter:
---> 86 collections.deque(res, maxlen=0)
87 except CastError as e:
88 for err in e.errors:

~/anaconda3/envs/dataflows/lib/python3.7/site-packages/dataflows/helpers/rows_processor.py in process_resource(self, resource)
9
10 def process_resource(self, resource):
---> 11 yield from self.func(resource)

~/anaconda3/envs/dataflows/lib/python3.7/site-packages/dataflows/processors/printer.py in func(rows)
62
63 index = i + 1
---> 64 prow = [index] + [truncate_cell(row[f], max_cell_size) for f in field_names]
65 yield row
66

~/anaconda3/envs/dataflows/lib/python3.7/site-packages/dataflows/processors/printer.py in (.0)
62
63 index = i + 1
---> 64 prow = [index] + [truncate_cell(row[f], max_cell_size) for f in field_names]
65 yield row
66

KeyError: 'שם הקדש'

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions