Visualize data lineage

Hi there!

I am trying to visualize the data lineage of certain attributes. The goal of the assignment is to determine what part of the data lineage still needs to be done. This is the case:

I have four different tables all related to each other that represent the entire data lineage of the attributes in table 1. For example:

Table 1 gives an overview of all attributes that I need the data lineage from. In this example I picked one of the attributes (Value of Product).

Table 2 gives me all attributes from which the value in table 1 retrieves its data. For example: (table1[Value of Product]) gets the data from the combination of (table2[attribute100]), (table2[attribute101]), (table2[attribute102]), etc.

Table 3 does the same as table 2 but for the attributes of table 2. For example: (table2[attribute100]) gets the data from (table3[attribute_x]), (table3[attribute_y]). However, it is also possible that there are blanks. This means that there is no known data lineage for the attribute in table 2 (! this means there is no data, there are no blanks in the original table).

Table 4 (source system) does the same as table 2 and 3 but it refers to the system level. For example: (table3[attribute_x]) retrieves its data from both (table4[System_1]) and (table4[System_2]).

All with all, the data looks like this (below):

Now I want to know how to visualize certain things:

1. How to automatically visualize this data into the tree I now made myself.
2. The count of the attributes in table2 that do not have a value in table3 (in this example the count should be 6)
3. The count of the attributes in table2 that do have a value in table 3 (in this example the count should be 6)
4. The count of the distinct systems in table4 (in this example the count should be 2), note: when I use the distinctcount option it gives me the count of all the systems in table4 without taking the filter (table1=value of product) into consideration.

I hope someone can help 🙂