Mar-28-2023, 02:39 PM
(This post was last modified: Mar-29-2023, 01:49 PM by Larz60+.
Edit Reason: fixed code tags
)
Can you let me know how to list the files using the query output in python.
Output :
DDD_$country_$client_$categorycode_FCT_H00$hierarchynum_$filecode_BD_20230225.csv
Output:Input Files In Unix
Directory : /DDD_Ext/input/
DDD_SL_NE_WAT_FCT_H001_QUAD_BD_20230225.csv
DDD_SL_NE_WAT_FCT_H002_QUAD_BD_20230225.csv
DDD_SL_NE_WAT_FCT_H003_QUAD_BD_20230225.csv
DDD_SL_NE_WAT_FCT_H004_QUAD_BD_20230225.csv
SELECT distinct(filecode), delimiter, a.country, a.catcode, a.client, hierarchynum, notify FROM ddd_mail_addresses a JOIN ddd_data_types b ON a.categorycode = b.categorycode and a.client = b.client and a.country = b.country JOIN ddd_conversion c ON a.categorycode = c.categorycode and a.client = c.client and a.country = c.country JOIN ddd_hierarchy d ON a.categorycode = d.categorycode and a.client = d.client and a.country = d.country where a.client='NE' and a.categorycode='WAT' and a.country='SL'
Output :
Output:Filecode Delimiter Country categorycode Client hierarchynum Email
"QUAD" "|" "SL" "WAT" "NE" 1 "[email protected]"
"QUAD" "|" "SL" "WAT" "NE" 2 "[email protected]"
"QUAD" "|" "SL" "WAT" "NE" 3 "[email protected]"
"QUAD" "|" "SL" "WAT" "NE" 4 "[email protected]"
"WEEK" "|" "SL" "WAT" "NE" 1 "[email protected]"
"WEEK" "|" "SL" "WAT" "NE" 2 "[email protected]"
"WEEK" "|" "SL" "WAT" "NE" 3 "[email protected]"
"WEEK" "|" "SL" "WAT" "NE" 4 "[email protected]"
Using Query need to list the files.DDD_$country_$client_$categorycode_FCT_H00$hierarchynum_$filecode_BD_20230225.csv