You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This snippet of code is not only wordy but also error prone if you have more than 100 tables, as that is the maximum returned from list_tables().
Proposed Solution
I propose we create a new function that is something like find_table("table_name") that will search all of your existing tables, on all available pages of results, and if the search string is found, that table will be returned. If multiple tables contain the same search string, maybe we return them all in a list? The function should also indicate what has or has not been found through logging messages to the user.
Example Usage
# find the table>table=p.find_table("table_name_BDS")
2020-12-0701:07:39INFO: Found1table(s) containing"table_name_BDS"
# inspect table data>type(table)
dict
# find the table>table=p.find_table("BDS")
2020-12-0701:07:39INFO: Found10table(s) containing"BDS"
# inspect table data>type(table)
list
The text was updated successfully, but these errors were encountered:
Current Issue
One way of finding the
table_wid
of an existing table is as follows:This snippet of code is not only wordy but also error prone if you have more than 100 tables, as that is the maximum returned from
list_tables()
.Proposed Solution
I propose we create a new function that is something like
find_table("table_name")
that will search all of your existing tables, on all available pages of results, and if the search string is found, that table will be returned. If multiple tables contain the same search string, maybe we return them all in a list? The function should also indicate what has or has not been found through logging messages to the user.Example Usage
The text was updated successfully, but these errors were encountered: