DSXchange

Hello Gurus I am new to Cognos 10.2 - have some basic expereince in FM . The scenario is that there is a report requirement which needs to check for key change in a perticular column and within the group of same key rows - do a few checks based on certain date columns and create a new column to flag...

Rest in peace.

Hello all, I am currently using "Hierarchical Data" stage in order to split the xml files into multiple files based on Batch Split Key. In order to create XML's I need to default certain fields in addition to get data from input (database) and few calculation fields (in transformer) Issue ...

That is good to know , I think this would have worked for me if the target was a sequential stage , However my target here is XML hierarchical stage. I may have more than one issue here . When I try to map a field which is defined type as <xs:simpleType name="NonRequiredStringDateTime"> to...

Thank you both .

I am able to convert it to non default format but as a string and not as a timestamp .
I will keep trying to troubleshoot/research on why I fail to change the format when I see change the default timestamp format in job properties .

Thank you all "At the job level: in Designer, Job Properties, Defaults tab, uncheck Project default, change the value." This is the first place I tested , but this test failed to change the format and I do not know why it is doing that ? Secondly in the following conversion - Isn't the for...

Yes , It makes perfect sense . But if the output is a Timestamp Field and you want the timestamp in that specific format (different from the default datastge format) , How can you convert that (or is there a Tag to be added to make that conversion ) ?

Hello everyone I wanted to know if there are any direct ways to change the timestamp format (Tried doing in job properties) but it didn't work file-transform-file StringToTimestamp(TimestampColumn,"%yyyy-%mm-%dd %hh:%nn:%ss") is the standard format for any string to timestamp conversion Bu...

Yeah , I think I realized the error (corrected the logic )
However something I am yet to understand is why do we
need to declare at the end
prev = result (according to your code )

instead of declaring it the first variable ?
svPreviousRo --> Inputlink.svColA

Thank you for the pointers However , the scenario (I think) is slightly different . Col 1 values above are calculated based on row numbers (a different requirement) , for example lets say I am calculating the value of Col 1 as floor(row number/5) in a stage variable . As a result of that first 5 rec...

Hello all, I have a job that does some calculations based on row numbers , lets say Column A has these values , I want another column B which counts based on change in value of A So Input say Column A , Column B 1 , 1 1 , 2 2 , 1 2 , 2 2 , 3 55 , 1 55 , 2 95 , 1 98 , 1 Basically Column B is a counte...

Hello

I am trying to see if there is a way to compare jobs available in say one project to another , if yes , will that also apply for jobs in different servers - This would be useful when you migrate jobs in steps .

Thank you

Thanks again , That works .

Thanks Craig
But isn't the IsValidDate function expecting a date input ?

Hello All, I have a simple operation where I am converting a 8 digit varchar string into date and then validating if the date is a valid date. So the job is dataset->transformer->dataset The issue ; One of the input string is '09001972' (MMDDYYYY Format) , so when I first convert into date it throws...