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 name recently for one of the columns in my Teradata view.

 

In Powerquery editor, i have only two steps "Source" and "Navigation" and no where I have used this column for any sort of transformation.

 

So, now  how to do resolve this "Column not found" error, when I'm not referencing to this column at all? 

Need Help

9 Replies

  • 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. 

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    I have a problem may

    I have a data base that provides me with more than 1000 columns with product characteristics to combine with my price lists.

    The problem is that for example when you are going to put new products a month you have changed 30 or 40 columns of name

    and for example if you had a command to convert the fields to text and another order to delete the null fields

    You have 80 errors of more than a minute each error.
    Is there a way to disable the errors and for example make the 960 that are fine and then make you the ones that are manually or ignore them?

    Because many times when there are no columans you do not have to do anything pq do not exist and it does not matter that you do not convert to text a column that no longer exists

    Thanks in advance