Run executable with parameters using tSystem or other components
Hi, I have csv file which holds 5 million records. The requirement is to fetch the each record from the file and decrypt the record using decrypt executable and store the output into another .csv file. So i was trying something like below to achieve the result, tFileInputDelimited --------> tSystem --------->tFileOutputDelimited. But i couldn't find the option to pass the .csv file input parameter to tSystem component to get it decrypt using the decrypt executable. Please help me to achieve the result using the above mentioned design or any viable approach. Thanks in advance,
Re: Run executable with parameters using tSystem or other components
you can do it using below design. tFileInputFullRow----tJavaRow or tSystem ---tFileOutputDelimited. tFileInputFullRow will read file line by line and each line will be available for next component. check once.