Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Token EOF Error

I am getting a token eof error on this query and I am not sure why. The week variable prints 26 when I run this with out the database part.   let week = Date.WeekOfYear(DateTime.LocalNow()) in w...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    Now what will your query do on Jan 1st 2021? 🙂

lbendlin's avatar
lbendlin
Super User
6 years ago

Show your new Power Query?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

let
week = Date.WeekOfYear(DateTime.LocalNow()),
Source = Odbc.DataSource("dsn=SystemDSN_ELK_PROD", [HierarchicalNavigation=true]),
gsec_Database = Source{[Name="gsec",Kind="Database"]}[Data],
#"data-resilient-all-2020week_Table" = gsec_Database{[Name="data-resilient-all-2020week",Kind="Table"]}[Data]
in
#"data-resilient-all-2020week_Table"

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    You're still not using the week.  Maybe you wanted to do this?

     

    let
    week = Date.WeekOfYear(DateTime.LocalNow()),
    Source = Odbc.DataSource("dsn=SystemDSN_ELK_PROD", [HierarchicalNavigation=true]),
    gsec_Database = Source{[Name="gsec",Kind="Database"]}[Data],
    #"data-resilient-all-2020week_Table" = gsec_Database{[Name="data-resilient-all-2020" & week,Kind="Table"]}[Data]
    in
    #"data-resilient-all-2020week_Table"

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      warmer, How do I concatentate 2020 and week? It needs to look like data-resilient-all-202026

      Expression.Error: We cannot apply operator & to types Text and Number.
      Details:
      Operator=&
      Left=data-resilient-all-2020
      Right=26

      • lbendlin's avatar
        lbendlin
        Super User
        6 years ago

        Right, i forgot your week is a number.

         

        Which brings up the next question - are weeks 1 to 9 supposed to come over with one digit or two digits? Ie "2"  or "02"  for week 2?

         

        Assuming "02"  you would do 

         

        Number.ToText(week,"D2")