Hi All,
In execute command im checking the file count using UNIX command wc -l filename.
The output from the command is below
20 filename
Based on the file count i need to run the next jobs(Ex:If file count is 0 then run JOB1 else JOB2.)
I need to fetch only filecount from the above unix command and need to compare filecount>0 or not.
In execute command trigger which logic should i need to provide?
I have tested the below logic in execute command activity trigger but no luck.
Trim(Substrings(Execute_Command_45.$CommandOutput[" ",1,1],1, Len(Execute_Command_45.$CommandOutput))) =0
Either of the jobs(JOB1 or JOB2) are not triggering.
I have created a small server job and hardcoaded a value in transformer stage ("20 filename") and tested the above substring logic and got the output as "20". So its working fine in individual job.
Not sure why its not working at sequence level.