Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am having Budget Data in Excel with Month as Text Data Type in Excel.
In my QV month is appearing as Numeric, I tried to convert this Month of Excel into number like..
Num#(ExcelMonth) & num(ExcelMonth) but did not work out.
When I concatenating Excel month to Calender Month it is giving me 2 value i.e 1 as Numeric & 1 as String...
I have checked over community as well but no success
Pls suggest how to achieve same?
Maybe like
LOAD
BudgetYear,
Month(Date#(BudgetYear & BudgetMonth,'YYYYMMM')) as BudgetMonth,
...
or just
LOAD
BudgetYear,
Month(Date#( BudgetMonth,'MMM')) as BudgetMonth,
...
Maybe like
LOAD
BudgetYear,
Month(Date#(BudgetYear & BudgetMonth,'YYYYMMM')) as BudgetMonth,
...
or just
LOAD
BudgetYear,
Month(Date#( BudgetMonth,'MMM')) as BudgetMonth,
...
Hello, i suggest to create mapping table and use it.
\\
MonthsForReplacing:
Mapping LOAD
StringName,
Number
FROM
(ooxml, embedded labels, table is Лист1);
Budget:
LOAD BudgetYear,
BudgetQuarter,
BudgetMonth,
ApplyMap('MonthsForReplacing',BudgetMonth) as BudgetMonthLikeNumber,
BudgetValue
FROM
(ooxml, embedded labels, table is Sheet1);