Represent i-META fields into hierarchical structure for Drill Up/Down.

Step 1. Create a Field Group

  1. Right-click in the i-META item window, and select [Add hierarchy items] to create a Field Group.



  2. Rename the created Field Group item to [Category Hierarchy]



  3. Select the 'Product Category', 'Product Subcategory', 'Product Sub-Subcategory', and 'Product Detailed Category' fields using [Ctrl] key for multiple selection, and then right-click and select [Copy Field] menu.  



  4. Rename the copied fields.  



  5. Drag & Drop the 'Product Category' field with the moouse to place it inside the [Category Hierarchy] folder. Then, sequentially place the 'Product Subcategory', 'Product Sub-Subcategory', and 'Product Detailed Category' inside the 'Category Hierarchy' folder.  



  6. Once the placement is completed, Drag & Drop the 'Category Hierarchy' to move it to the 'Product Info' folder.

    Since modifications are not possible after adding the field, you need to delete the group and set it again.


    If you want to use a field as a general field in parallel, copy and reuse the field.


Step 2. Retrieve Data


  1. In the Import Data window, perform a query including the fields.




  2. In the query screen, click the hierarchy icon of the relevant field, then select the desired item to retrieve the data.



    Drill Up


    How to Change the Group Type?
    Right-click on the relevant field and select the [Change Group Type] to view.