Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created and exported a job a while back and it does convert csv files to tde. I have 900 csv files and they were separated into folders. I have a main folder and inside it is folder1 having the first 100 csv files then folder2 having the second 100 files..and so on. I have bat file that will call this exported job looping through all folders in Main folder. It was like below
echo off
set PATH=E:\TALEND_64Bit\TOS_DI-r99271-V5.2.2\;%PATH%
echo "START TIME: %time%"
REM Loop through all stores and Run TDE Conversion
echo "%errorlevel%"
cd /D %~dp0
REM 373 Days Daily CSV to TDE
for /D /r E:\Main\Store %%a in (*) do ^
start E:\Main\ScheduleJobs\TDEConversion_373DaysDaily_0.1\TDEConversion_373DaysDaily\TDEConversion_373DaysDaily_run.bat %%a%
cd /D %~dp0
wait
type nul > E:\Main\Store\TDEStore_Final373D.tde
echo "FINISH TIME: %time%"
My job consists of tfilelist > iterate > tfiledelimited >tmap>tTableauExtractOutput
In tfilelist I have checked global expression as filemask and filemask ="*.csv"
Now I needed to re-export the job...however it is not producing tde files as expected. What should i do..I need help here really badly
Thanks everyone!