Importing an Excel/XML

[Madhan007]

Hi,
I am trying to import Data into a table. The table has 4 fields, of which one field is a Reference to the table itself. When I try to import XML file through import XML functioanlity, no records are being imported. when I try to import an excel sheet, Records are not being created properly as one of the field is reference to itself.Please pour your suggestions on how I can do this.

Thank you!

[Community Alums]

Hi @Madhan007 ,For the HR Profile field in your transform map, you should be able to map from the User in your file (assuming it's there, since it's mapped in your screenshot) to HR Profile as the target field and referenced value field name "user".  If the User field is already being mapped, it won't let you select it again.  You can then script the HR Profile mapping to read and find the appropriate profile based on the provided user.

[Madhan007]

Hi @Community Alums , I dont understand what you are saying. I did not attach any Screenshot.