Hi everyone
I have data coming in via a csv file - no problems - want to import into table - I can work this one out no problem -
however the csv file will come in three different layouts
column 1 name standard etc...
version 1 will have x number of fields that are not in 2 or 3 and versions 2 and 3 will be slightly different to each other
will it on an import see that field 8 for example is different? and ignore
(basically will the import look at the field names on the table and assign these values accordingly )
if so then I need to name all of the datafields possible ?(which i don't have an issue with)
I have data coming in via a csv file - no problems - want to import into table - I can work this one out no problem -
however the csv file will come in three different layouts
column 1 name standard etc...
version 1 will have x number of fields that are not in 2 or 3 and versions 2 and 3 will be slightly different to each other
will it on an import see that field 8 for example is different? and ignore
(basically will the import look at the field names on the table and assign these values accordingly )
if so then I need to name all of the datafields possible ?(which i don't have an issue with)