Skip to main content
Question

I have a csv with no column names hat has a code field and northing/easting data . I need to split out the csv by code and map to a template gdb using the code to map to the correct table and map columns to the correct column


Forum|alt.badge.img

Currently I set the projection in the reader for the csv to match the gdb. I then added a Feature Writer transformer for the fanout creating feature classes in a staging gdb. My problem now is how do I get the feature classes the feature writer created back into the workspace so I can then use the attribute manager to map to my final gdb. I tried to use the Feature Reader transformer to add these back but have not been able to figure that out yet.

3 replies

rahulsharma
Safer
Forum|alt.badge.img+10

Hi @patrick17​ 

Technically you do not need temp gdb, you should be able to write directly to the final geodatabase if you are satisfied with the workflow.

Although, using FeatureWriter/FeatureReader should work. Are there any particular issues you are having when reading the data back? Example here


Forum|alt.badge.img
  • Author
  • May 6, 2022

I have the majority of things figured out but I am stuck. I am writing from a csv where all the fields are text. One of these fields contains a date 10/11/2021. I need to load this to a geodatabase that has the field formatted as a date. I have tried many different things and am probably just missing something but I can't get this to map. Attached is what my current workspace looks like. I believe I need to do this in the attribute manager using the dat time format but I am not figuring out how to dot his properly. imageimage


rahulsharma
Safer
Forum|alt.badge.img+10
patrick17 wrote:

I have the majority of things figured out but I am stuck. I am writing from a csv where all the fields are text. One of these fields contains a date 10/11/2021. I need to load this to a geodatabase that has the field formatted as a date. I have tried many different things and am probably just missing something but I can't get this to map. Attached is what my current workspace looks like. I believe I need to do this in the attribute manager using the dat time format but I am not figuring out how to dot his properly. imageimage

@patrick17​ You should be able to use the functions you have set in the Attribute Manager it might be hard for me to troubleshoot without sample data.

I would recommend using the DataTimeConvertor transformer instead.

Alternative, you can Manually map the attribute type in CSV reader parameter windows as well

see here CSV_Parameters


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings