Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
LOAD
FY.YEAR as "FY",
// "MONTH" as "Month",
MonthName("Begin of Month") as Month,
Quarter as Quarter,
FROM [lib://Desktop/Tequila & Cream H1 2014-15.xlsx]
(ooxml, embedded labels, table is Sheet1);
WHERE Match(FY.YEAR,'2013-14');
I have a file with a lot to data. I only want data relating to FY 2013-14. Its stored as a text field in the excel sheet. I tried using FY instead of FY.YEAR, but that didn't work either.
I would say the issue is your Script has wrong ; before the Where Statement, this should work
LOAD
FY.YEAR as "FY",
// "MONTH" as "Month",
MonthName("Begin of Month") as Month,
Quarter as Quarter,
FROM [lib://Desktop/Tequila & Cream H1 2014-15.xlsx]
(ooxml, embedded labels, table is Sheet1)
WHERE Match(FY.YEAR,'2013-14');
I would say the issue is your Script has wrong ; before the Where Statement, this should work
LOAD
FY.YEAR as "FY",
// "MONTH" as "Month",
MonthName("Begin of Month") as Month,
Quarter as Quarter,
FROM [lib://Desktop/Tequila & Cream H1 2014-15.xlsx]
(ooxml, embedded labels, table is Sheet1)
WHERE Match(FY.YEAR,'2013-14');
Daniel is right, you can also try the below approach as well using Exists function:
filter:
LOAD * INLINE [
Year
2012
2014
];
test:
LOAD
FY.YEAR as Year,
// "MONTH" as "Month",
MonthName("Begin of Month") as Month,
Quarter as Quarter,
FROM [lib://Desktop/Tequila & Cream H1 2014-15.xlsx]
(ooxml, embedded labels, table is Sheet1)
where Exists(Year);
Thanks,
Angad
Thanks. Silly error. Rahul