Linking multiple columns of one table to a single column in another table

[sagnikrana]

Hello Everyone,

I have the below table (project_task) for the tasks and subtasks.

The tree looks something like this (X,Y,Z,A,D are root nodes):

I have a table(task_tree_format) like this in database, which depicts the project tasks in depth format:

I want to place the name1, name2 and name 3 in pivot table so that it appears in hierarchical format(with expand and collapse buttons) in my Qlik Sense sheet.

My requirement is -

When task 'B' (NAME2 column) is selected in pivot table, it should perform the operation based on the same 'Task Name' in project_task table.

Eg.. If I select Task 'B' in pivot table, it should trigger the 'Task Name' B in project_task table.

In short, I want to associate NAME1, NAME2 and NAME3 columns with the 'Task Name' column in project_task.

I request your help on how to proceed with this in the load data editor.

Appreciate your help regarding this.

Thanks!

Sagnik