DSXchange

All, Need a help on IF function. This is with my old post earlier I have data looks like, 03:12:11Available 00:10:11Busy 12:13:09Unavaialble 09:08:11On Call Issue is that, I have output column in Ascending order, Available,Busy,On Call,Unavailable In transformer, I am trying to use a function, by wh...

Okay,I tried this way. So, I changed the sql query and it is pulling data like, userid,time_spent,status,date sam,0:15:12,Free to talk,2013-04-20 sam,1:15:22,Busy,2013-04-20 sam,00:47:15,available,2013-04-20 sam,04:15:11,out of desk,2013-04-20 jim,02:10:15,busy.2013-04-20 jim,00:15:10,free to talk,2...

Thanks Guys. So far I divided the column in SQL query in source data grouped by status and userid.
So, it looks like, userid,hour,minute,seconds,status and date. Now i can try pivoting the data.

Will also try your suggestions for sure.

Thanks,

Thanks Ray. It is quite tough for sure. In Pivot stage, if use array of 3 for on call,busy,free to talk. its repeating the same for next other rows which does not make sense. )pivoting on status. Its coming like, userid,beginningdatetime,endingdatettime,status1,status2,status3 sam,2014-04-12 7.00am,...

All, Need one help on rows to column spilling in datastage. It is a parallel environment where source is db2 database. Basically we have four columns, userid,begiinigdatettime,status.endingdatetime,duration. Sam,2014-04-12 7.00am, on call,2014-04-12,7.30am, 1800 Sam,2014-04-12 7.30 am,busy,2014-04-1...

Have a question on the code. It was compiling fine but in the code it says sequential file right. But we have the column in database which will be parsed in multiple rows. Initial stages look like, ODBC--TRANSFORMER--SEQUENTIAL FILE. So, if the code is used in transformer it is not about sequential ...

Ray,
Thanks for your reply. I tried the code, it was not giving the expected result. I will let you know what was the error.

Column 2 is the call id (which we added in beginning of each parsed row) and column 4 is the column which has the data to be parsed.

Thanks again.

Ray, there in one previous job, we have pipe delimiters and two stage variables. The data looked like, 9999,0,0,20150925125011,201409251259940,,,,, |9915,0,0,201509254857441,20140925151088,,,,, and so on. To parse it we used-- StgVar= Change(DSLink1.Column4, "|", "|": DSLink1.Col...

Yes, Ray is correct, it is a call log. So, will have calls from 6AM to 11.59 PM.

Hi All, Need a help on parsing data I have a sql database column with 3000 bytes. Sample data looks like for that single row, 23:05:05: Aaaaaaaaaaaa23:05:05: Bbbbbbbbbbbb23:05:05: BBB: 983001587423:05:05: AAHH: 111123:05:05: XXXXXXXXX23:05:06: YYYYYYYY23:05:06: ZZZZZZZZZZZZ23:05:07: CCCCCCCCCCC23:05...

Thanks everybody. I will start reading the materials very soon. Craig, Thanks for your suggestion to post it in general blog..Worked great..:) Also, if somebody can open the non visible part for a while that will be great. As said before, my premium membership is not activated yet though I paid almo...

All, Hope you are doing well. Need an advice from you. I am actually working in Datastage for almost 3 years now, currently 9.1. But my current project only uses server jobs not parallel. Basically I started with Server job datastage career. It seems like, all the companies in the market are using p...

Thanks. Yes, that is the reason..I renewed the premium membership which expired last month but not yet activated for two weeks. B and C are child tables and all of A,B,C have a process control table which updates while records load and reports run based on the update . If JobA has 0 records then I c...

Craig,
I tried to include the @INROWNUM before seeing your post. You are correct, it is loading 0 records even though the constraints is there. I meant changes, by including the suggestion posted above.

And can't see your comment as it is blocked.

Thanks.

Thanks everyone. Will try to implement the changes and will keep you posted.

There is an @INROWNUM system variable, could we use that. Like, @INROWNUM >0 in constraint. Lets try all of these.

Thanks again.