DSXchange

Hi,

I have a requirement to execute the Unix command and pass the value the next JobActivity

In the Execute command how do I pass the two unix commands
awk -F"|" 'BEGIN{IGNORECASE=1;} $1~/DATA/' #ps_EDW_StdHrs.p_Source_Dir#/*/#ps_EDW_StdHrs.p_Source_FileName# | cut -d"|" -f8,9

Here I read the file and extract only the column 8th and 9th

But Execute Command is not accepting the Parameter in between the Unix command. Could some one can help how to handle this requirement?

You can print the eight and ninth field from awk

Thanks, I will have mutiple records how do I read only 1 record using the Awk Command.

Use exit command