Dimensional conditional grouping

[qingkong]

I have two Excel's

Want to achieve the result as shown in the picture below

LOAD
Material,
avg6
FROM [lib://AttachedFiles/AVG6.xlsx]
(ooxml, embedded labels, table is AVG6);

LOAD
Material,
Unrestricted
FROM [lib://AttachedFiles/Mb52_Stock.xlsx]
(ooxml, embedded labels, table is Mb52_Stock);

[vinieme12]

Temp:

LOAD
Material,
Unrestricted
FROM [lib://AttachedFiles/Mb52_Stock.xlsx]
(ooxml, embedded labels, table is Mb52_Stock);

Left join(Temp)

LOAD

Material,

avg6

FROM [lib://AttachedFiles/AVG6.xlsx]

(ooxml, embedded labels, table is AVG6);

Main:

Load * 

, (Unrestricted/avg6) as Unrestricted_avg6

,If((Unrestricted/avg6)>9,'>9'

      ,If((Unrestricted/avg6)>6,'6-9'

      ,If((Unrestricted/avg6)>3,'3-6','1-3'))) as Interval 

Resident Temp;

Drop table Temp;