Skip to Content
Author's profile photo Rahul Pandey

Import File with Multivalued Hierarchy Table using tuple

Import File with Multivalued Hierarchy Table using tuple

I have created this document in the reference for the thread

I tried tuple concept for the thread and suggested the same in the below steps.

Step 1: Create a Hierarchy table with only one filed.

Step 2: create a tuple table as like below, please note this tuple table should not be multivalued.

step 2.JPG



Create the Process Role Code field in the main table and choose yes for both Display and Unique field.

Step 4: Now create a tuple filed as mass and make it as multi valued and call the tuple table which was created.

step 4.JPG

Step 5:

Now create the map in import manager as per to populate the data for Mass main table.

As the requirement is to have combination”Data Object + Process Role Code + Workflow Region + Material Hierarchy”

So call all the fields of tuple in the set Tuple update filed in the Map fields and values.

step 5.JPG

Step 6:

Now choose the Approver code in the Matching and set the default import actions as below.

step 6.JPG

Step 7:

Now trigger execute import and check the result in Data Manager.

I have imported the below Data’s and got the output as below

step 7.JPG


Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.