i have a folder path where every day file will be placed. Lets say one file is placed with year_month_date as file name. If one file is placedin the folder it should load and for tomorrow one more file will be placed with date as tomorrow. tgen it should load yesterday’s file and today’s file. As the field name and field count is same, it will concatinate. Like this we will get one file every day So All files should load.
I tried the sane and working fine. But my concern is going forward the year will change like 2019 and month also changes. so for that i have created two variables one is for current year and other is for current month. How to add this variable in from path.