Forum Discussion
How to perform excel data query with multiple changing conditions
Added the following step between the Source & SelectedTodaysFolder steps:
NoSystemHiddenFile = Table.SelectRows(Source, each ([Attributes]?[Hidden]? <> true) and ([Attributes]?[System]? <> true) ),Not tested but that should solve the issue - let me know
Hi marshalltj67. Coud you post an update please?
Hi Lorenzo ,
By name manager I meant "Define Name" source that you get to by going to "Formulas" then "Name Manager".
I was able to name all the columns via this name manager function by selecting all the columns, then clicking "Create from Selection" and then naming the column off the top row.
This should be fine as long as all the columns remain the same. I am not sure if the assigned "name" for the column will update in the "Name Manger" if the query outputs another column.
Thanks!
marshalltj67 Glad I could help you & Thanks for your feedback
- I understand! I am working this code on a different stand alone system so it is hard paint the entire picture.
It looks like when I run a query and the output updates my columns, my assigned names in the name manager update and if a new column is added, that column remains "Column #" so all I have to do is assign a new name so I should be good to go!
I appreciate the help and my apologies for the delay! Hi marshalltj67
Obviously I don't have the complete picture (don't know what you other query does) and consequently don't understand why you need to name the columns in the Name Manager...
Re. This should be fine as long as all the columns remain the same. I am not sure if the assigned "name" for the column will update in the "Name Manger" if the query outputs another column
Answer is clearly No. A query doesn't change/update anything in the Name Manager
When you have time and to help people who Search it would be appreciated you Mark as solution the post from Jan 06 2024 06:54 PM with attached file PQ3_marshalltj67.xlsx. With a few tweaks this could be re-used - Thanks