Hi
Brian,
Open a spreadsheet or text editor.
Create a comma-separated values (CSV) or
Excel
XML files Import the data,
Load the data from a spreadsheet into a table.
STEPS:
In the left navigation pane, navigate to System Import Sets > Load Data.
Select Create table or Existing table
Enter the following information.
Field Value to use
Label anyname(own) CSV/XML/EXCEL
Table name Populates automatically
Source of import File
File Path to your CSV/XML/EXCEL file
Sheet number 1
Header row 1
Click Submit.
The system displays a success message after importing the file.
After you import the data, create the transformation logic.
using the following data.
Run the transform
Build the transformation logic to map data from the staging table to a target table.
A transform takes data from the staging table, maps it according to the transform logic, and loads it into the target table.
click Create transform map.
Fill in the Table Transform Map with the following information and right-click the form header and click Save.
Field Value to use
Name: CSV Transform
Source This field populates automatically.
Target table Which table you want to transform(ex:inident..etc)
In Related Links, click Auto Map Matching Fields.
The system adds the Field Maps related list.
In Related Links, click Mapping Assist.
Drag and drop the Sponsored by and Sponsor fields into the center Field Map column so that Sponsored by is in the left column
and Sponsor is in the right column.
Click Save.
The system displays the Table Transform Map record.
Verify that any incoming data are in a format the system recognizes.
In the Related Links list, click Transform.
The system displays the import set and transform map to be used in the transform.
Click Transform.
The system takes data from the temporary staging table and uses the transformation
logic to insert new records in to the table.
Thanks&Regards
Haseena.
PS: Hit like, Helpful or Correct depending on the impact of the response
