Forum Discussion

marshalltj67's avatar
marshalltj67
Brass Contributor
Dec 28, 2023
Solved

How to perform excel data query with multiple changing conditions

Hello All,   I was looking to see if it is possible to perform a data query for a file that changes daily within a folder that changes daily... For example the folder is named 28 DECEMBER 2023 TEXT...
excel
  • Lorenzo's avatar
    Lorenzo
    Jan 06, 2024

    marshalltj67 

     

    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

Lorenzo's avatar
Lorenzo
Silver Contributor
Jan 15, 2024

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

marshalltj67's avatar
marshalltj67
Brass Contributor
Jan 16, 2024
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!
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jan 16, 2024

    marshalltj67 Glad I could help you & Thanks for your feedback

Resources