DSXchange

Huh? It is behaving exactly what you want. 2 records, 1 record updated in original stage, and 1 got rejected and updated in the follow-up ODBC stage. Remove reject link, only 1 get updated as originally. I don't see what the problem is, can you clarify? the issue is Both the records should be updat...

Hi, I am working on ODBC stage to connect progress database. I am applying join on two tables and then getting two records as a result of the join. and then after getting the two records , am trying to update the two records depending on the keys But while updating i have kept a reject link to ODBC ...

Follow the steps to create a parallel function in the designer. I have not created a parallel function before :( . If you are sure it is only two instances of "," that you need to replace then then you might as well use a field() function to get the values a1, a2 and a3 and concatenate th...

Follow the steps to create a parallel function in the designer. I have not created a parallel function before :( . If you are sure it is only two instances of "," that you need to replace then then you might as well use a field() function to get the values a1, a2 and a3 and concatenate th...

Follow the steps to create a parallel function in the designer. I have not created a parallel function before :( . If you are sure it is only two instances of "," that you need to replace then then you might as well use a field() function to get the values a1, a2 and a3 and concatenate th...

Maveric wrote:This might help you.

viewtopic.php?t=106358

Hello Maveric,

I could see the C code ....real helpfull....But how can i use this in the transformer stage... please guid me..

thanks

Hi,

I have a string with a1,a2,a3.....i just want to apply transforamtion where the string becomes a1YYa2YYa3


Please suggest...

I tried using convert but it replaces 1 for 1

thanks

No I am reading the data as

One record as one column

So no problem while reading..

Maveric wrote:But to read the data you would be having N columns, N being the max number of columns. Is my understanding correct? i.e,

1,a1,a2,Null,Null
2,b1,b2,b3,b4
3,c1,c2,c3,Null

Is this how your data will be?

Hi, But the maximum limit is not known.... the number of columns can be any valuee as shown 1,a1,a2 :its 3 here 2,b1,b2,b3,b4 :its 5 here 3,c1,c2,c3 :its 4 here It could be N such columns in any record. Thanks. What you need is a horizontal pivot. Use pivot stage. Specify all four fields in the deri...

Hello ,


I have input file with variable fields as shown bello

1,a1,a2
2,b1,b2,b3,b4
3,c1,c2,c3

I need the result as

1,a1
1,a2
2,b1
2,b2
2,b3
2,b4
3,c1
3,c2
3,c3

Tryied to find the result from vertical pivot....search ...

But failed as the input file has dynamic fields

Please suggest..

thanks.

But i also need the records which are not satisfying any of the three cases, both from lookup as well as from reference and i need those records to be moved to table2 Store the reference in three different hashed files. Hashed file 1 - Col1 as key , Hashed file 2 - Col 2 as a key and so on. Compare ...

Hi, I have a requirment where in I need to match records from two different sources (1.table,2.sequential file->reference). The matching criteria is based on columns which are nullable and not unique.so there is no column which can be made as a key for moving the records through hash file. Condition...

Pls check the topic "Logic Help" or search for "Logic Help" http://www.dsxchange.com/viewtopic.php?t=112175 Hi I need some help about my logic. My input data is like below ID Type 1001 20 1001 20 1001 20 1003 20 1003 23 1003 20 1003 23 1010 20 1010 23 1010 20 1010 23 1010 24 1010...

If IsNull(DSLink3.Date) then 0 else If StringToDate(Trim(DSLink3.Date),"%dd/%mm/%yy")[1,2]= '**' Then 0 else 1 Please Do NullHandling In stage variable and then go ahead with validation: like: If Trim(DSLink3.Date) = '' then 0 else If StringToDate(Trim(DSLink3.Date),"%dd/%mm/%yy"...

Please Do NullHandling In stage variable and then go ahead with validation: like: If Trim(DSLink3.Date) = '' then 0 else If StringToDate(Trim(DSLink3.Date),"%dd/%mm/%yy")[1,2]= '**' Then 0 else 1 Getting the same warning Conversion error calling conversion routine date_from_string data may...