DSXchange

hi, i have two inputs, both are sequential files with datatypes varchar i need one output in sequential file with datatype varchar my input1:- sequential file col1 col2 col3 col4 col5........col10 111 80 0001 111 80 0002 111 80 0003 222 84 9301 222 84 9302 222 84 9501 222 84 9502 222 84 9701 333 84 ...

hi, thanks for replying. my input has three columns1)claim_id 2)line_nu 3)adj_type all of them are varchar(10). there are three types of adj_types1)80 2)83 3)84 in my input each particular claim_id has adj_type either 80 or 83 or 84 or combination of all of them(80,83,84) or combination of any two o...

hi my input Claim_id line_num adj_type 1 01 80 1 02 80 1 03 80 2 01 80 2 02 80 2 01 83 2 02 83 3 97 84 3 98 84 3 99 84 4 92 84 4 93 84 5 01 80 5 01 83 5 95 84 6 01 80 6 02 80 7 01 80 7 01 83 7 02 80 7 02 83 7 92 84 7 93 84 7 94 84 my output shuld be claim_id lin_no adj_ty 1 01 80 1 02 80 1 03 80 3 9...

[quote="g_rkrish"][quote="pattemk"]hi, my input columns:- claim_id adj_id 1 00 1 01 1 02 2 00 2 00 3 00 3 01 3 01 4 00 4 02 5 00 5 00 5 01 o/p claim_id adj_id 3 00 3 01 3 01 5 00 5 00 5 01 my ouput shuld have only those rows where for a particular claim_id has combination of x nu...

hi, my input columns:- claim_id adj_id 1 00 1 01 1 02 2 00 2 00 3 00 3 01 3 01 4 00 4 02 5 00 5 00 5 01 o/p claim_id adj_id 3 00 3 01 3 01 5 00 5 00 5 01 my ouput shuld have only those rows where for a particular claim_id has combination of x number of 00 and y number of 01 i.e i dnt want those rows...

hi, i have three columns, as below claim_id(varchar) service_number(varchar) adjustment_type(varchar) -- 123 1 11 123 2 12 123 4 13 123 3 13 456 56 12 567 10 11 567 67 11 847 3 11 902 4 11 902 4 12 902 4 13 420 7 13 420 4 13 i need to get the all the rows whose adjustment_type is 13, if no 13 in a p...

[quote="ds_developer"]You could try: DATE[7,4]:DATE[1,2]:DATE[4,2] The DATE I am referring to is the name of the date field coming into the transformer. John[/quote] hi john thanks for replyin but in my input dates are like 5/4/1998, 11/5/2001,5/21/1996,11/31/1994 and your formula works fi...

[quote="ds_developer"]You could try: DATE[7,4]:DATE[1,2]:DATE[4,2] The DATE I am referring to is the name of the date field coming into the transformer. John[/quote] hi john thanks for replyin but in my input dates are like 5/4/1998, 11/5/2001,5/21/1996,11/31/1994 and your formula works fi...

hi everyone

can anyone help me how to convert mm/dd/yyyy hh:mm:ss to CCYYMMDD

INPUT DATATYPE--> VARCHAR(24)
OUTPUT DATATYPE-->VARCHAR(8)

PLZ HELP

THANK YOU