Hello all, I have been working to create automation scripts for a project and I have been basing a few of the actions on our Excel requirements documents.
I had setup the actions to select columns in the Excel document with a specific value thinking that all of our requirements documents were in the same format. Unfortunately, each document is different, so the automated action won’t always get my desired columns.
I was wondering if there was a way to be able to setup a query that would return a column name from the Excel document based on the value I am looking for.
A similar query would be this one that works in SQL Server, which can return table names, column names, data types, etc.:
select * from information_schema.columns
Trying this while querying on the Excel document connection was unsuccessful, but is there another query that might work instead?