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

kBahu · ‎09-25-2020

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.

sneha65 · ‎09-28-2020

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.

View solution in original post

LindaE · 3 weeks ago

The solution to this issue; is likely you have not saved the Imported file on your hard drive- you are using a files in download folder.