reject logic issue with space

marpadga18 · Post by **marpadga18** » Thu Nov 04, 2010 9:40 am

Requirement is : Src_Seq_stage>> Trans _stage>>>sql servtgt

Reject stage from Trans_stage

In this scenario I am able to reject records to reject file and load remaining records to tgt table if there is no space in || column it is rejecting to reject file
UK ||SUSAN MCCLUSKEY |c/o: FLEMING

But in this scenario it is not rejecting
UK | |SUSAN MCCLUSKEY |c/o: FLEMING
the problem is with space If I keep space while testing it is not rejecting and loading that space to tgt table which is should not do

constarints i am giving in the transformer are
Output link: Src_Input_link.Address_Book_Number <> ''
reject link: Src_Input_link.Address_Book_Number = ''

so need some input how to overcome this problem
I have many coulmns but i posted only 1 column any input

:(

vinothkumar · Post by **vinothkumar** » Thu Nov 04, 2010 9:41 am

Check Trim function

marpadga18 · Post by **marpadga18** » Thu Nov 04, 2010 9:42 am

vinothkumar wrote:Check Trim function

i need to reject records if it has space

vinothkumar · Post by **vinothkumar** » Thu Nov 04, 2010 9:46 am

You need to reject recrods if there are no values and space in Src_Input_link.Address_Book_Number . If yes, for reject link use

Trim(Src_Input_link.Address_Book_Number)=''

marpadga18 · Post by **marpadga18** » Thu Nov 04, 2010 11:02 am

vinothkumar wrote:You need to reject recrods if there are no values and space in Src_Input_link.Address_Book_Number . If yes, for reject link use

Trim(Src_Input_link.Address_Book_Number)=''

Hey thanks ""Vinoth"" & ""DSXchange""is working fine thanks for ur input