My goal is to be able to batch process a folder of CSV tables to a geodatabase template. My process right now is CSV -> XY Event layer -> shapefile -> append to template geodatabase. But the problem is that some attribute are not added even though the column headers are the exact same in the CSV and the geodatabase.
My question is how would I get the schema of both the CSV and the geodatabase to match exactly so the process of appending is completely seamless?
All of the Target Fields have A Matching Source Field but it is not picked up automatically. I need it to be automatically matched while using append so that I can batch a folder of CSVs, rather than process them one by one.