Forum Discussion
Dynamic query table
Hi there, Does anyone know if it is possible to dynamically name a query based on the data returned? Thank you, Pete (Further reading: I am creating a report from a folder of 15 different types of CSV files but not all 15 are in every folder; so I want to have query names relating to the expected content.)
2 Replies
Hi,
Do you mean the query name is the one like in the picture? It seems there isn’t a way to change it dynamically by now. But you still can refer to this post https://social.technet.microsoft.com/Forums/en-US/c4cec033-4b02-41ea-a0d7-de120eee457b/dynamic-table-names?forum=powerquery. Maybe you can find the thing you want. Please tell me if you need any help.
Best Regards!
Dale
- Thanks, Dale, useful resources. I think this all gets a bit meta when you want to dynamically name tables and not parameters. I'm dealing with unstructured data so am in a schema-last world (hence variable numbers of tables)
