Line connection of two points in different rows
I have to connect every warehouse to all the shops it supplies to.
So in the columns, I have a column named data_type, the type is either warehouse or shop. I have to connect from warehouses to shop. Any leads on doing this by line connection? I have tried creating a common column and prioritizing them by data_type and it doesnt seem to solve my query. I have attached what i want (wiw) and what it does (wid).