String To Number Conversion

[Anonymous]

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?

[swuehl · Accepted solution]

Maybe like

LOAD

   BudgetYear,

   Month(Date#(BudgetYear & BudgetMonth,'YYYYMMM')) as BudgetMonth,

  ...

or just

LOAD

   BudgetYear,

   Month(Date#( BudgetMonth,'MMM')) as BudgetMonth,

  ...

[smirkinaa]

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);