I have a task to check the multiple file in dir with same name and fail the cmd task in informatica if found duplicate files. I am able to get the duplicate file count from dir but unable to fail the task after the finding multiple files in source dir.
below is the command I am using to get the duplicate file count . Please suggest if found duplicate file my cmd task should fail the wf.
set filescount=0 & for %f in (abc123.txt) do @(set /a filescount+=1 > null)
this command working fine to get the duplicate count of file. when I add count check like file count greater than 1 its not working as expected. Please help on this.
below is the command I am using to fail a cmd task in informatica:
set filescount=0 & for %f in (abc123.txt) do @(set /a filescount+=1 > texfilecount & if not texfilecount == 1 EXIT 1 )
this one is not working as expected.