#!/usr/bin/env python

# Inner-joins two map spreadsheets A->B and B->C to A->C

import csv

import os.path

import sys

import warnings

    reader = csv.reader(stream)

    map_1_cols = reader.next()

    for row in reader:

    stream.close()

    # Join map 1 to map 0

            out_orig = row[1] # used in "No join mapping" error msg

            # Look for a match

            suffix = ''

            while True:

                try:

                    break

                except KeyError:

                    # Heuristically look for a match on a parent path.

                    suffix = sep+new_suffix+suffix # prepend new suffix

            # Write new mapping

            else:

                msg = 'No'

                msg += ' join mapping for '+out_orig

                set_error(msg)

        elif row[2] == '': # also no comment explaining why no input mapping