DSXchange

Issue is at the source data

Hello DS gurus, I am trying to connect the SQL Server through windows authentication. I have included the below entry in the .odbc.ini file [ODBC_SQL] Driver=/home/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmsss00.so Description=DataDirect SQL Server Wire Protocol driver Database=<Database_...

Hi DS Gurus, When i am loading the French Characters into Dataset. They are not being loaded properly. Some of them are loading properly and others are not. The loading of the French is random. some are good and some are not Job Design: Unstructured data --> Transformer -> Dataset Sample data: J'aim...

Thank you,

it worked with index and field

trim(Columnname[ Index(columnname,'_',3) +1,50])

Hi All,

We have a file with records as below
ABC_123_DATA_RRR_TTT_OOO
ZXC_123_DATA_SSS_PPP_LLL

I want to fetch the all the data after 3rd delimiter
FOR EX: final output should be
RRR_TTT_OOO
SSS_PPP_LLL

Can you please help me on this

My best guess is that the job is corrupted. you can create a new job name, delete the existing and rename the new job to Old job name

I am not sure if this is the full error message, did you try to force compile the job ?

Hi All, I am trying to create a IA rule for value check for one of the column Rule: Field should have all three alphabets ,numbers and Special Character ~ ( tilda) otherwise the rule should fail Example : ABCD~2016187~1 ABC~2016187 the above data should be passed and below should be failed FNAL~ 123...

The issue is with the source file. it is having hex 00 (UTF-16)
I have changed it to UTF-8 and it is loaded sucessfully

iconv -f UTF-16le -t UTF-8 testsample.txt > sampletest.txt

Hi Craig, It is showing when i read the data in sequential file and Dataset view data. Now I have loaded the file into another sequential file, when i view the file in UNIX it is showing correctly which is good. but my other issue is with the transformation, when i do substring to 10 characters it i...

Hi Craig,

It is showing as below without braces
O r d e r R e a d y F o r P i c k u p _ E N _ Q A B o u n c e d

it is same for all the 15 columns

Hi DS Gurus, I am reading a tab delimited file using a sequential file stage. When I view the file every character has a space between them. When I view the file in Excel, Textpad or UNIX the file looks good. For example: Sample source file looks like below OrderReadyForPickup_EN_QA Bounced But when...

Hi, I have renewed the 3 year membership On November 13 2015, it is been two weeks but still it is not activated/Renewed I have sent couple of mails to the below Email ID's but there is no response from them either rick@dsxchange.net, membership.director@dsxchange.com, editor@dsxchange.net Can anyon...

Thank you Craig,

My bad, i ignored the check boxes

Thank you Thomas .. it worked

I used the below specifications in Modify stage and the job completed successfully without warnings