Re: Dynamic query table

factgasm · ‎05-22-2017

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

Expect what you inspect - look at your data

v-jiascu-msft · ‎05-23-2017

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

Dynamic query table.jpg

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

factgasm · ‎06-22-2017

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)

Expect what you inspect - look at your data