Dynamic query table

[factgasm]

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.)

[v-jiascu-msft]

@factgasm

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.... Maybe you can find the thing you want. Please tell me if you need any help.

Best Regards!

Dale

[factgasm]

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)