Hi Team,
I have scenario where i do have materials
M1,M2,M3.........M50
If i select M2 i need to get equivalent part M4,M30
and if i select M5 i need to get equivalent materials likes M8,M12,M21,M29 and so on.
How can i achieve this.able to write a query for this
select distinct material_number(dim1) from table1 where dim2 in (select distinct dim2 from table1 where country='India')
i am getting the values from backend.
From sheet1 when i click MK48483727 then i need to get some random material numbers.
Same if i execute from backend i am getting a value like ML25925927,MK48483728,ML25925928,MK48483729
Can someone please help.
답변 2개
Can you redo the question?
It is not clear what do you need to get and the workbook not match with your question.
Thanks
