DSXchange

Hi,

Src file Sequential, Pipe Delimeter, DataTYpe Varchar(10)

0001,0002|Truck,Rail Car
0001|Truck
0002,0001|Rail Car,Truck

Output needed

0001|Truck
0002|Rail Car
0001|Truck
0002|Rail Car
0001|Truck

Thanks Craig, you are right i set delimiter to comma instead of pipe.

Datatype is Varchar(10), yes i mean one column.

Input

0001
0002
0003
0001,0002
0005
0003,0004

Source is sequential file and Pipe delimiter, how can we read source data if it like 0001,0002 in 1 line.

When i read source file it is unable to read after comma.It is reading all 6 lines data but not after comma data.

Input is a txt file and output table.

Input

0001
0002
0003
0001,0002
0005
0003,0004

Need out put like

01
02
03
01,02
05
03,04

Iam running a job with dataset name test1.ds, after the job run the dataset name need to be change to test.ds in the same path specified.How can i do in orchadmin,help me out.

Col 1, Col 2, Col3
1234, "DATASTAGE1",2345
1234,"DATASTAGE2",
1234,"DATASTAGE2",
1234,"DATASTAGE2",2345

this is working for me,put null field value as ''

remove oracle table and put peek and run.

I tried to do this stage variables,the field populating empty

Convert('0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ!&^-_\,','',upcase(LNK_ARNGM_CLASS.ACCOUNT_FIRST_NAME)) - StageVar1

Convert(StageVar1,(' ',len(StageVar1)),LNK_ARNGM_CLASS.ACCOUNT_FIRST_NAME)

I tried to do this stage variables,the field populating empty

Convert('0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ!&^-_\,','',upcase(LNK_ARNGM_CLASS.ACCOUNT_FIRST_NAME)) - StageVar1

Convert(StageVar1,LNK_ARNGM_CLASS.ACCOUNT_FIRST_NAME)

I tried to do this stage variables,the field populating empty

Convert('0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ!&^-_\,','',upcase(LNK_ARNGM_CLASS.ACCOUNT_FIRST_NAME)) - StageVar1

Convert(StageVar1,str(' ',len(StageVar1)),LNK_ARNGM_CLASS.ACCOUNT_FIRST_NAME)

remove unnecessary character from First Names(Cominf from source). Valid characters are 0-9, A-Z, ^-_^.,!& ''
All other characters are considered invalid and should be replaced with ' '"

need replace command to use in tranformation logic

copy the sequencer and delete the original job,and re-name the copied job,it will work fine

awk -F',' '{if(NR>=9){print $0}}',if it a seq file filter the rows by using command

Hi,

Iam having a seq file in source and seq file as target,when i run my job today i must get file ext name as system date and time with hrs and seconds

each time i run the job file name must be updated with system date and time.