Dear,
When I refresh my query 'GitClean,' the error message pops up showing that 'expression.error we couldn't find an excel table named ' bug_trend_data_filterdatabase'
It's weird that every step of my GitClean doesn't include reading the worksheet 'bug_trend_data' so I can't find anyplace to delete any step relating to 'bug_trend_data_filterdatabase.' I've tried search in data source setting, but I couldn't find any....
Link of the file:
Hi Yachu,
Look at the step where you have the list of sheets and tables. If there is a filter applied in one of the source file sheets, there will be an entry named FilterDatabase, you have to filter out these entries. Filter the Kind column for Sheet only, or tables.
Dear Catalin,
Thank you for the reply!
I've tried as you said but still got the same message. (I've posted in images)
So I am not sure what you mean of ''a filter applied in one of the source file sheets'' and "filter out these entries."
Is it possible that you can provide any further step-by-step guidance or pictures?
Thank you so much!!!
Look at your query steps, from the beginning of the query.
Filter the Name column to remove FilterDatabase entries from that list.
In the second step, Expanded Content, you are combining all those tables, many of the entries from that list are defined names (Andrew, Bernie, Bryant), referring to a specific range of cells.
Are you sure you need those? Before expanding content, make sure you have in the list ONLY the relevant data sources. Expand Content will not magically clean what should not be there, only you decide what is relevant.
Dear Catalin,
Wow, problem solved!
Thank you so much for the guidance.
I don't know before expanding content will automatically add source to existing query. Thanks for the notice!
I'll definitely take a look into it.
Grateful~