Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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;