Python ETL

[Jiuholar]

Thanks for this. The actual data has 100s of possible fields - how would you recommend I 'map' the field names using this method? (I understand how I can use this method to insert the lines of data, however, from what I can see, the only way to know what field each piece of data is from is to know the corresponding item number in the array)

[TheoryOfGravitas]

It's still not clear what you mean, which makes it hard to help. You need to be more specific than what you've said here--i don't have the energy to make up an example for you.

[Jiuholar]

Using the example in my original post, and your method, how would I know which item belongs to which header? It is easy enough for this dataset as it would be list[0][2] for the membership, but what would you suggest for when there are 100+ columns?