| 14 |
|
import os |
| 15 |
|
|
| 16 |
|
if __name__ == '__main__': |
| 17 |
< |
tableReportFileName = r"C:\Users\eborges\Documents\Cases\Endo\Temp\2021.08.26 Aspect Delivery - Database object report (with Navigator but not top 50 rows)\SQL_Db_tab_col_info (SFA)-tableonly.csv" |
| 18 |
< |
fieldReportFileName = r"C:\Users\eborges\Documents\Cases\Endo\Temp\2021.08.26 Aspect Delivery - Database object report (with Navigator but not top 50 rows)\SQL_Db_tab_col_info (SFA).csv" |
| 17 |
> |
tableReportFileName = r"C:\Users\eborges\Documents\Cases\Endo\Temp\2021.09.10 Aspect Delivery - Multi Systems DB Tables and Fields Reports\SFA_db_info-tableonly.csv" |
| 18 |
> |
fieldReportFileName = r"C:\Users\eborges\Documents\Cases\Endo\Temp\2021.09.10 Aspect Delivery - Multi Systems DB Tables and Fields Reports\SFA_db_info.csv" |
| 19 |
|
|
| 20 |
< |
outputFileName = r"C:\Users\eborges\Documents\Cases\Endo\Temp\2021.08.18 IQVIA - Navigator data dictionary\RedgraveAnalysis(SFA).csv" |
| 20 |
> |
outputFileName = r"C:\Users\eborges\Documents\Cases\Endo\Temp\2021.08.18 IQVIA - Navigator data dictionary\RedgraveAnalysis(SFA)2.csv" |
| 21 |
|
|
| 22 |
|
## List of terms to search in the table and field names |
| 23 |
|
interestingList = ["COMMENT", "NOTE"] |