DSXchange

Sorry, how would you actually save the value from the sequential file to the job parameter?

Thanks ended up using LEFT and worked.

I have some data coming down the pipe like this:



Need to add another column in the next step to this data that is coming downstream and the value for this column will be the same for every row. It is a date found in a csv file.

Looking for a way to add a column and populate the value of that column for every row. The value of that column for every row will be coming a csv file with a date in it.

It Is Varchar. Everything is set to varchar (stage var, input, output) for now just to get this portion fixed first. So, also I made a copy of the job deleted the transformer stage. Added a new one in, mapped to it did input to output and no characters were added. Once I used the conversion function...

Setup: Pulling in CSV to sequential file, record delim is UNIX. When I view data with the seq definition everything looks good. I then put the data through into a transformer stage which look at the last column of the sequential file. I used the following function in a stage variable: If Trim(mylink...

Have the following:

a,b,2
a,c,6
k,c,8
k,b,4

Need:

a,b,2
a,c,6
k,c,8
k,b,4
all,c,10
all,b,6
a,all,8
k,all,12
all,all,20

What is the easiest way to achieve this using parellel?

In case anyone at some point views this thread for an answer. I ended up using the curl shell command to pull data and save it to disk. Then process the file from there since the stage in question is not available in 9.1.

You were equally as awesome. Thanks very much for your time!

Ray you are awesome. Thank you very much for your help, if I was a bit more clear to start we could have saved ourselves some typing.

Will try to be more clear. Currently, I have a ExecCommand stage which executes a simple shell command. Here is an example for test purposes: echo "#UserVariables_Activity_5.Date#,2,3,4,5,6" > /somepath/test_1.csv I would like the parameter or variable (it doesn't matter which) #UserVariab...

No as a variable or parameter in datastage. That can be used in other stages.

I'm running a shell script through the EXEC stage. The command requires yesterday's date in YYYYMMDD format in part of the shell script. How can I get a user variable/job parameter with yesterdays date in the format so it can be used in this stage?

Got my v9.1 in June of this year. Wasn't too bad, ended up passing without any previous exposure to datastage prior to the 2 month in lab exercises I did for my self paced virtual training. I hope that gives others hope!

Hi actually using DS 9.1 which doesn't have this stage. Is there a way in v9.1?