Forum Discussion
Error (row index 1)
Thank you, Sir! Is there a possibility that i will not be able to find this? As in, if i have deleted it by mistake. I am not sure. I really hope to be able find that missing piece so that I can update it. The error shown relates to only this "Table20191307" but yet, I cannot locate addindexcolumn in the query. I understand it is difficult as you do not have view to all my queries. I really appreciate every possible step you are advising. Thanks.
hi there, this issue is now fixed. The issue was oddly with a column where i had the year in TEXT. e.g. 2020. I then made a formula to combine TEXT with "-1-1" where I can then convert to date column, and to extract YEAR. This was working fine for me in this 1.5 year until now. Once I removed all the M code below, and kept the year as TEXT. I had no other errors. I still can't figure out why these steps below will trigger the issue. I got to know these issues as I was working to start from scratch again. Then it hit errors at this step.