Multi Level Marketing

[Alessandro87]

Hello!

trying lo load the MLM connection between users from the data I have, but have not find the right way yet.

Fields are the follows:

id
path
depth
 
For example, in the first row I could have:
id = /123-abc-456
path = /369-bgt-123/000-abc-258/123-abc-456
depth = 3

Second row:
id = /000-abc-258
path = /782-azx-123/000-abc-258
depth = 2

Third row:
id = /782/azx-123
path = /782/azx-123
depth = 1

This means that the users in rows 2 and 3 are directely connected but the first one is only connected with the 2nd

So, how I could load the data to create these connections? 
In a table I have to show for example an user and all the users connected with him

Thanks!

[vinieme12]

can you post some sample data in excel so members here can help you better?

[Alessandro87]

Sure.

Thank you

[Anil_Babu_Samineni]

@Alessandro87 What is the input here (Is Excel is input or data source?) and expected result?

[Alessandro87]

Hi,

the input is from a data source, the expected result is for example in a table to have all the users and when i select one of them to have all the users connected.

Example, if i select the user with id /782-azx-123 i will basically have 2 rows

1st row: id /782-azx-123, path /782-azx-123, depth 1 direct_user null
2nd row: id /000-abc-258, path /782-azx-123/000-abc-258, depth 2, direct_user true

If i select id /000-abc-258 i will have:

1st row: id /000-abc-258, path /000-abc-258, depth 1, direct_user null
2nd row: id /362-agh-327, path /000-abc-258//362-agh-327, depth 2, direct_user true
3th row: id /123-abc-456, path /369-bgt-123/000-abc-258/123-abc-456, depth 3, direct_user false
4th row: id /546-jkl-532, path /369-bgt-123/000-abc-258/123-abc-456/546-jkl-532, depth 4, direct_user false

Uploading the new excel, there was a mistake.

[Chanty4u]

May be can use hierarchy function

Hierarchy (id, path, id) as HierarchyTable;