Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Column not found error

Hi Team,   I went through many of the solutions provided to takle this issue.  however, in my scenario the situation is different.   I'm quering data from Teradata view and I changed a column nam...
Need Help
Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

Could you share the M code from the advanced editor ?
 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Fowmy ,

    Below is the m query

     

    let
    Source = Teradata.Database("ttttttt", [HierarchicalNavigation=true]),
    D1 = Source{[Schema="xxx"]}[Data],
    ITOp= D1{[Name="zzz"]}[Data]
    in
    ITOp

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Fowmy Hi Fowmy,

       

      Any idea why i get the error. 

      • Fowmy's avatar
        Fowmy
        Super User
        5 years ago

        Anonymous 

        can you do a fresh connection two terror data again?