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).


Image icon wiw.png4.67 KB
Image icon wid.png4.1 KB

(1) Answer