DSXchange

Hi, Even i had the same issue removing the special characters from this input records. We have written a script that search for special characters in the input records and replaces all the special characters with emptyspace. We called this script in external filter or external source depends on the ...

Hi All, I have a fixed width input record, am using column import to split that single column into 10 columns. If my input data is having null and empty string for some columns, will column import split those (null/emptystring) values correctly according to the length? Please help me on this. Thanks...

Hi,

Try running the job with no transformation in transformer(One on One Mapping).

If it works fine, then I think it may not be the problem with compiler.

Thanks,

Senthil P

Hi All, I have to use round robin partitioning in my flow at the earlier stage, like after the seqential file stage. I am trying to specify round robin partitioning in the input of the transformer but it popups UNKNOWN NAME error. Its not allowing me to specify the round robin partioning in the tran...

Hi ShaneMuir/Mahadev.v,

Thanks for your Info, I will do a search on Vertical Pivot.

Thanks,

Senthil P

Hi All, I want to perform some calculation for each group from aggregator, For Example, Input Data: Col1 Col2 100 abc 100 def 100 ghi 200 oio 200 yui My Desired Outut is: Col1 Col2 100 abc:def:ghi 200 oio:yui Can i achieve this in Aggregator stage itself?? Please help me out... Thanks, Senthil p

I havent specified the delimiter anywhere, but when i use the char as my datatype for both the Input and output columns of Column import i am getting this error. "Field "col1" lacks whitespace delimiter, at offset: 4 " Will Column Import surely work for fixed with file? Please le...

Hi, I tried giving char to my field types, even then i dint get the output. In col Import stage, i set Record length is Fixed and no field defaults. For My input seq file, I set the Record length as fixed. If i change my datatypes to char, it says that" White space Delimiter is missing at offse...

HI ArndW, Thanks for your reply, I tried it, The columns are splitted but the values are not proper. for my given input: 1234qwer0989lkjh The output column values are: col1-1234 col2-0989 col3- col4- There is no value for col3 and col4. also col2 value is wrong. Why the output is coming like this, i...

Hi All, I have to split up my input record in to 4 columns. My Input Seq file has a single column. Input data is: 1234abcd9089qwer 0989mnop0909sdfg My O/p file needs four columns, Expected o/p data is: col1 -1234 col2 -abcd col3 -9089 col4 -qwer How shall i achieve this through the column import sta...

HI Pravin,

It seems in your job at some stages you enabled Reject Mode=Output, but you have not given the reject link.
If you dont want reject output, make it as "Continue". If you want the Reject then provide the reject link to that stage keeping Reject Mode=Output.

Thanks,

Senthil P

HI ArndW,

You are correct!!!

Now Count(InputField,CHAR(11)) to find out the vertical tab delimiter is working fine.

13 is the octal value for the vertical tab. 11 is the decimal value for the vertical tab

Thanks a lot.

Senthil P

Hi ArndW,

My Delimiter is Vertical tab. I want to know the count of my Delimiter in a record. i used Count(InputField,CHAR(13)) as you suggested. But its not working.

Please let me know about this.

Thanks,

Senthil P

Hi All, I am having the records with delimiter as ascii value \013. I wanted to find out the number of delimiter(\013) available in the single record. I tried it using Count(Inputfield,"\013") but its checking for \013 in the record not for the delimiter. so if my delimilter is of some spe...

Thanks Poornima.Chandramouli for your info.

Havent tried it yet, will let you know once it works out.

SenthilP