Source field on Field map entry not showing up and unable to select from dropdown

[kBahu]

I have a transform map to edit. The data source is defined and CSV file is used as a data source. The new file contains some additional columns which are not present in the previous data source file. When I loaded this new file and run transform, the source field is not showing up on field maps. This field contains dropdown values(Please refer below image for more info)

I clicked on auto map matching fields

Even if i want to create new field map entry in this transform map the source field doesn't show up.

I tried to import xml record from another instance but its still not working.

[Ankur Bawiskar]

@kBahu 

your import set table seems corrupted.

Please delete the table from tables section and also the fields

Please validate the file, extension etc you are using to load the data.

Try with fresh load

Regards
Ankur

[Willem]

Would not suggest deleting the complete table. As we validate other set is working. As I suggested, delete the existing import set and transform map or only the columns and create again. You could check the data set by loading it on different environment and see if you get the same behavior.

[Willem]

You can create a new import table and change the transform map to run for that table.

Or you can remove the columns that you think are causing this from your current import table.

[sneha65 · Accepted solution]

Hi,

There is a possibility that junk column have been added while exporting csv/excel file. If you delete it that should resolve this issue. Ideally if junk column is added in import tables, you could not list the values in table but may be after New York version it is possible. For checking junk column, you can go table configuration and check for the column names.

[kBahu]

Thank you Sneha, this worked. I have deleted that junk column and now I can see the source fields again. Thank you once again.