DSXchange

Hi Friends,

I have a requirement in which i need to pass values in different columns in a txt file or an csv file to a User Variables stage. How can I achieve this? Please help me with this issue. Thankyou.

You can perform the read with the sequential file stage. And then can move the column values into your user variables. There are many stages with which you can do this. If you are simply moving the data into user variables then you can use a copy stage. If you are transforming the data you can use a transformer. Just check the requirement and use the correct stage accordingly.

nayanpatra wrote:You can perform the read with the sequential file stage. And then can move the column values into your user variables. There are many stages with which you can do this. If you are simply moving the data into user variables then you can use a copy stage. If you are transforming the data you can use a transformer. Just check the requirement and use the correct stage accordingly.

Hi Nayan,

I wanted to do this in Sequences.. So I cant use transformers etc.. Is there a way that I can get the values in a text file to the User Variables stage, from where I can pass those values to corresponding jobs??? Thankyou.

You will need to shell out to UNIX, perform the selection there and then return the results to your job sequence. What utility you use to do this depends upon how complex your selection is.

Will the same job run in more than one invocation with different parameters at the same time?

If no, you can try the following
1.) take copy of DSParams to some default
2.) append your list of parameters and make it DSParam

This way, you can use environment variables which will be assigned by your external text file.

Alternatively there are several routines and shell scripts floating around which can be used to extract parameters from flat file or tables.

I for one would never suggest anyone monkey with their DSParam files in this manner or try replacing it with a job specific list. There's no need for any kind of 'trick' like this, never mind the fact that it can be... dangerous.

As noted, getting values from a flat file can be as simple as a 'cat' to echo them to standard out or as complicated of a custom routine you may need. We would need more details to give more detailed help, however. How many fields from this flat file do you need? Are they all individual job parameter values? If so, perhaps this post will help.

Yeah, you can try it with the Unix commands. But if any kind of manipulation is required then you may go for a shell script.

A simple cat command (Execute Command) upstream of the User Variables stage should suffice. The user variable derivations can use Field() functions to extract the relevant columns from the row that was read.
(I've assumed that the file has one line. Without that assumption the requirement makes little or no sense.)

Hi All

I have set up a Sequence Job that uses a shared parm set. The Sequence Job looks like this:
Execute_Command---> UserVariables ---> Job_Activity

I execute the cat command in the Execute_Command
The output is trapped in the UserVariables via Execute_Command.$CommandOutput
I can't get the output into the Job_Activity shared parm set.

Can someone help?

Thanks in advance for any help.

Rather than hijack / sidetrack someone else's slightly related post, please start your own.

Apologies chulett. Since this seems to be a solution I could use I thought it made sense to continue the conversation. Will send a new post.

Thanks.

tbtcust wrote:this seems to be a solution I could use

Somewhat but now we know you have an 8.x/PX question unlike this 7.x/Server issue you posted into. And a parameter set doesn't really equate well to the User Variables stage. Plus you can decide when the issue is resolved over there. So... new post.