- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-25-2020 03:56 AM
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.
Solved! Go to Solution.
- Labels:
-
Enterprise Asset Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-28-2020 07:57 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-25-2020 04:09 AM
Have you tried different browser?
What happens if you try add field mapping to a different transform map? You also do not see the field?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-26-2020 10:49 PM
On other transform maps i do get an option to add or modify the source field. I think the issue is on the import set table, somehow looks like this source field (column on the import table) got corrupted? How to revert back to the earlier version?
I was trying to modify the transform map so i loaded a new file to this data source (import table) which was having few new values (columns) and after that this issue occurred.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-26-2020 10:55 PM
Have you tried checking in the Mapping assist, a Related links in Transform Map form. In Mapping Assist ideally you should see all the source fields.
Hope this helps!
Thanks,
Saji
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-27-2020 08:17 AM
