DSXchange

Thank you bart12872. This seems to work just fine. Thanks again.

Hello chulett,

There is a transformer that receives the groups and performs the evaluations. and a couple of joins to create the output.

Thank you for your reply bart12872 In the example below the key field is what I am using to group the data. Once grouped in the calling job I pass the groups to the shared container. In the shared container I'm evaluating fld_1 and fld_2. For a group when fld_1 is "1", there must be a &quo...

Hello All, - How can I pass multiple groups of records to a shared container for processioning at the group level? - Is there a way to have a shared container wait/pause while a group of records is being processed? I have a need to pass groups of records to a shared container for transform as a grou...

Thanks Andy.

Hello All, I have a need to look at groups of records and detect which group is missing data that is in other groups. The number of groups is always unknown. See example below. Is this possible? Thanks in advance for any help. Input: GRP_ID, Fld_1 =-=-=-=-=-=-=- AAAAA, 11111 AAAAA, 22222 AAAAA, 1111...

Hello All. Apologies for this question. I know I have seen chatter on this topic in the past but cannot seem to locate a link. I have a need to create a text file via a Sequential File stage. I need to pass the file name, which is unknown at runtime and created in a Transform stage. I'm using 8.5, P...

Thanks Mike.

Hello all, I have installed 9.1 client and server on windows 7 64. The InfoSphere Engine Resource Service will not start. The following is displaced by the service: "Windows could not start the InfoSphere Engine Resource Service on Local Computer. Error 1075: The dependance services does not ex...

Thank you ray. I could not decide if I needed one or many containers. This helps.

Hello All,

I am thinking about creating a shared container that will have three different processing paths to handle three different types of records coming from three different Jobs.

If I update a single path in the container do I need to recompile all three jobs?

Thanks in advance for any help.

Thank you chulett. I was relying on the documentation example way too much.

I have coded the transformation loop and it works fine.

Thanks again.

Thank you for the reply and suggestion asorrell. I looked at the Transform Loop and Pivot Stage. They both seem to rely on the codes being in separate columns. This is not the case for me. I need to duplicate a record based on the content of one column where the content of that one column is separat...

Hello All, I have a task to duplicate/repeat records in a file based on a particular column. All columns are separated by "|". This particular column has codes that are separated by commas. As an example, if there are three codes on one record, that record should be outputted three times, ...

I have a date in the following format Dec 15 2011 3:17PM.

How can I reformat the date as a timestamp (yyyymmddhhnnss)?

Thanks in advance for any help.\