DSXchange

Thanks for those quick responses..I would like to add some more details to my original query..The names that are to be standardized are like MR B ALEXANDER * WILSON and the patter for this is PIF*F There are lot of cases where I have a low repeating freq. patterns and I thought using input override ...

Hi, I know this is not related to the current topic discussed but felt that someone can suggest a solution. I am trying to use input pattern override for name standardization and I am not able to use a '*' astrix in the input pattern (eg. F*+G). It throws an error when testing the input data with an...

Yes that is fine.. let me give an example..for US PREP I have 11 fields AddLine1,AddLine2,AddLine3,City,Stage,Zipcode,UnparsedAdd1,UnparsedAdd2,UnparsedAdd3,UnparsedAdd4,UnparsedAdd5 The logic is like data in UnparsedAdd1-5 will not be available when there is data in AddLine1-3 and City,Stage,Zipcod...

Hi Thanks a lot for your advise, I got the solution for this. I used the below command in the External source stage and it worked fine..

find ./ -maxdepth 1 -name "*.txt"

Thanks again..

Hi, I was trying ot enter literals like ZQNAMEZQ or ZQADDRZQ before the fields when trying the PREP rulesets. After running the job the literal is being added to the data in some cases and is working fine in some other cases. I would like to know, whether there is any specific order in which we defi...

Hi, I tried reading multiple xml files using External Source stage.. I mean I used the ls command to list out the files in the dir. But the issue is there are around 50000 files in the dir and I am getting the error like too many return values. I shall send the exact error by tomorrow. Seems like th...