Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All.
Can anyone get me the following output,
For your reference, Please find the attached file.
Thanks,
Vinod
Try like this in the script
Table: LOAD MIS, If(MIS < 6, Dual('0<=MIS<6', 1), If(MIS < 12, Dual('7<=MIS<12', 2), If(MIS <18, Dual('13<=MIS<18', 3), If(MIS < 24, Dual('19<=MIS<24', 4), If(MIS < 30, Dual('25<=MIS<30', 5)))))) as New_MIS FROM [..\..\Downloads\MIS Data.xlsx] (ooxml, embedded labels, table is INPUT);