dynamically select the column at runtime

deesh · Post by **deesh** » Sat Jan 16, 2016 12:15 am

Hi,

I want to select the required column dynamically at run time.

Ex: out of 5 columns, may i will select any column at runtime, output should be only selected column data..

chulett · Post by **chulett** » Sat Jan 16, 2016 8:39 am

Schema files and RCP.

chulett · Post by **chulett** » Sat Jan 16, 2016 2:30 pm

Not sure why this question was posted four times, including once well after I'd answered in this one. I nuked the other three.

Thomas.B · Post by **Thomas.B** » Tue Jan 19, 2016 6:33 am

You can also use a Modify with the "KEEP" keyword.

chulett · Post by **chulett** » Tue Jan 19, 2016 8:48 am

Honest question - dynamically?

ray.wurlod · Post by **ray.wurlod** » Tue Jan 19, 2016 3:47 pm

The Modify stage KEEP specification can (and should in your case) be a job parameter.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue Jan 19, 2016 4:23 pm

Not certain what kind of environment you are doing this in, but I hope it isn't financial... this is the kind of thing that drives auditor's crazy!

ray.wurlod · Post by **ray.wurlod** » Tue Jan 19, 2016 7:54 pm

kduke · Post by **kduke** » Thu Jan 21, 2016 7:10 pm

You could do it with a CASE statement and a job parameter.

vamsi_4a6 · Post by **vamsi_4a6** » Fri Jan 22, 2016 7:33 am

I have used modify with parameter as below

Keep #parameter1#

where parameter1 is the column name but not sure what i need to mention in the output column tab of modify stage since it is dynamic and also i can not use job parameters in column tab

ArndW · Post by **ArndW** » Fri Jan 22, 2016 9:19 am

Unfortunately the side effect of "KEEP" is that all other columns are dropped. You want to do something like

Code: Select all

MyNewColumn[:type]=#parameter1#

and then you can work with "MyNewColumn" in the job; at the end don't neglect to

Code: Select all

#parameter1#=MyNewColumnName

so that the column is placed back into the stream.