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.
Thanks - I've managed to create a table using the import and data transform, and have created another table which was used as the destination for the staged data.
The only thing I seem to be missing are the rows of data from the spreadsheet that was imported, they don't appear to have been populated into the columns, any ideas?
1. Transform
2. Table destination
3. Example of unpopulated column
You need to navigate to your Table to view the data populated. Type in your Table name and then do as below:
TABLENAME.LIST and hit enter in Application Navigator to see what has been transformed.
Let me know if you are faicng an issue here.
Regards,
Shloke
From the source table u_nhsl_tray_codes I seem to have the correct number of entries
