ETL and Data Integration tools - Modern ETL software for everyone

Help me please

I need to import a file which has 45 columns in it and I constantly get a
problem around the 37th column where your product gives the 37th column the
logical name [F36] repeated (it gives the same logical name to the 36th
column as you would expect). The rest of the columns (up to 45) get named
[F37] onwards in sequence. When I map a column to [F36] it gets mapped to
both the 36th and 37th column and I cannot get the data I require.

Please help....

Jim

Jim

May I suggest the following

If you data source is odbc connection , excel file or a text file with field names in first line.
Click in the middle of source data and select Set first line as Field's names.

If it does not help you may try to edit list of your source fields manually

Click on template tab and edit SourceFields section.

Please let us know the outcome
Mike

Mike,

I am trying to load a series of pipe-delimited text files into an Oracle database. For each file, when I am specifying and opening the SOURCE, your product opens a certain number (not all) of the columns in the file (36 in the case of the 45 column file below). When I click on the red plus sign to add columns, the next column gets allocated the same logical column name ([F36] in the case below) so the I get two(2) [F36]’s. Continuing to click on the red plus sign adds [F37] to [F44]. I am then unable to map anything to the real [F37] (now the second of the two [F36]’s) and while I am able to map out the rest of the file, I am unable to load the lost column [F36](2).

I have tried editing the template but to no avail – I have tried saving it to a *.vis file, editing and loading this but to no avail….

Help,
Jim

Can you try latest version please

Mike