I need Column Name to be processed along with data

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
hcdiss
Participant
Posts: 26
Joined: Sat Oct 14, 2006 1:45 am
Location: Boston

I need Column Name to be processed along with data

Post by hcdiss »

i have 270 columns in a single row...i need to place a constraint on a column name ..for example..
my input data is -

Benefits_Amt Salary_Amt Reimbursements_Amt ......
100 40 10

I want to put constraints such as...if the column name contains the word 'Reimbursements' ..then process A, if column name contains the word 'Benefits' then process B..so on...

for this i need to capture the column name in my transformer...any idea how to achieve this?.....pls keep in mind that there are 270 columns..and in dont want to do manual typing work (i already have a labourous approach :-( )
hcdiss
dsedi
Participant
Posts: 220
Joined: Wed Jun 02, 2004 12:38 am

Re: I need Column Name to be processed along with data

Post by dsedi »

hcdiss wrote:....for this i need to capture the column name in my transformer...any idea how to achieve this?.....pls keep in mind that there are 270 columns..and in dont want to do manual typing work (i already have a labourous approach :-( )
If the source is any DB then first load them into a file with "first line column names" property..
using that file you will be able to process column name in transformer..
Accept that some days you're the pigeon and some days you're the statue.
hcdiss
Participant
Posts: 26
Joined: Sat Oct 14, 2006 1:45 am
Location: Boston

Re: I need Column Name to be processed along with data

Post by hcdiss »

Thank you very much for such quick response...
hcdiss
agpt
Participant
Posts: 151
Joined: Sun May 16, 2010 12:53 am

Post by agpt »

Can you please update us whether it worked for you?
Post Reply