Forum Discussion
Missing Data Error on Refresh
PowerDR I don't know of a way around adding all columns but what you can do as a quick way around having to manually add all the column names is to click on Choose Columns select all the columns you need and click Ok. That will add all the column names for you. Then all you have to do is add a comma after the closing bracket } and MissingField.UseNull and close the parenthesis. Similar to the solution I provided above.
Hope this helps.
Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.
PowerDR I don't know of a way around adding all columns but what you can do as a quick way around having to manually add all the column names is to click on Choose Columns select all the columns you need and click Ok. That will add all the column names for you. Then all you have to do is add a comma after the closing bracket } and MissingField.UseNull and close the parenthesis. Similar to the solution I provided above.
Hope this helps.
Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.
Thanks so much Watsky. I got it sorted by selecting the columns as you said and then added "Remove Other Columns".