DSXchange

chulett wrote:Use the Field() function to take the first field from a space delimited string.

The length of the field may vary , because originally field type and length is varchar 254.

can you give me the function syntax

thanks

Srini

Hi

I have a field (column) of type varchar and values like below

$60000 cash
$3835.50 MRY SINGLE.

I want to populate like below

$6000
$3835.50

can any one suggest me the solution

Thanks
Srini

Change your "same" partitioning to partition by the key you are using. Also, change the setting for "Log Statistics" to True so you can see in the director what the stage sees as inserts or edits. Could be that the files are truly not the same. From Unix do an md5sum on both jus...

Thanks Vivekananda, I got it and it is working fine

Regards

Srini

In the Transformer I need to use below logic. For ADDRESS field derivation When I am using below syntax it is througing error (RED colour) in the Transformer Can any one Please correct the below syntax if INPUT_Link.Field_NM_LNS =1 then INPUT_Link.LN_1_TX :' ': INPUT_Lin.LN_2_TX :' ': INPUT_Lin.LN_3...

hi this is my sample output [<accList> <accEntry> <msgId>A1111</msgId> <sysId>VGI</sysId> <actInd>2</actInd> <accNum>0002-09891824205</accNum> <accDtls> <modInd>Securities</modInd> <custId>CIF5849794</custId> <accTyp>16</accTyp> <brchAcc>USA</brchAcc> <accOpDt>12-jun-2008</accOpDt> <accSta>01 </accS...

[<accList> <accEntry> <msgId>A1111</msgId> <sysId>VGI</sysId> <actInd>2</actInd> <accNum>0002-09891824205</accNum> <accDtls> <modInd>Securities</modInd> <custId>CIF5849794</custId> <accTyp>16</accTyp> <brchAcc>USA</brchAcc> <accOpDt>12-jun-2008</accOpDt> <accSta>01 </accSta> <accClDt>31-dec-9999</ac...

<accList><accEntry><msgId>A1111</msgId>
.
.
.
.
<relEntry>
<seqNum>1</seqNum>
.
.
.
</relEntry>
HERE <accEntry> should be closed with </accEntry>
<relEntry>
<seqNum>1</seqNum>

Thanks

Srini

Thank you

srini[/quote]

The hole record is very big that is why I am not able to send you

/accList is closing correctly at the end of the file with </accList>

<accEntry> is not closing with </accEntry> for each record

and <msgId> is closing properly for every record


Thank you

srini

can any one let me know the solution for my problem

Thanks

I need to generate a xml data file Transformer stage is used before Xml output stage Out put Xml file is generating correctly except Starting tag is not ending with closing tag /accList/accEntry/msgId/text() . . . /accList/accEntry/relList/relEntry/relSta/text() <accEntry> tag is not closing with </...

Hi

I am getting repeted warinings for many fileds, warning is given below.

Can you please give me a detailed advise, how to fix it

Join_39: When checking operator: Dropping component "ACCT_SAG_ID" because of a prior component with the same name.

Thanks

Srini

Hi

I need to generate a unique sequence number for each row of ouput(starting from 1 and increment is 1). Is it possible, if yes can you please let me know the code in detail

Thank you
Srini

For my question can any one send the solution please

Hi I am using transformer in Parallel Extender job. Transformer with two output links (First and Second), to split the input data. I want to write a constraint for First(Link name) link. when values for perticular input column (Role_ID) has AAAAA then I need to populate PPPPP If column (Role_ID) has...