Hello,
I have been provided 30 thousand plus choice options that need to be selected by end-users. The information provided is effectively a table with 3 columns.
Tray ID, Tray type and Tray name.
Each Tray ID is associated with a type and name.
The plan is to populate presumably a table which will then be referenced by a field on the required SC portal item. My question is what is the best way to go around importing all of these values (Manually would take forever!).
I have created a new table with the columns Tray ID, Tray type and Tray name but can't seem to work out how to get these columns to work together or how to import the thousands of choice values.
Below are some screenshot which may help you get started:
Now within transform map select your Target Table where you want to upload data to and then click on Auto Map Field Map related link as shown below. This should define your field Maps if not then manually define it by clicking on New and then select Source and Target fields as shown below:
Once this is done, make sure to choose a coalesce as well to avoid duplicate record transformation within your field map.
Click on transform.
Hope this helps. Please mark the answer as correct/helpful based on impact.
Regards,
Shloke
This is great - assuming I do not want to map the new values to an existing table, can I just create a new one with the 3 columns and then use the transfer map to this new table?
