Search results for query: *

Hi Vik, My experience is limited to 8.1.1 and mostly in a Windows environment. My understanding of 8.1.1 is that workflows are owned by the repository. There is no ability to define a single workflow that runs across multiple repositories in 8.1.1. You could maintain the workflow in one...

If you are targeting a flat file then you can create a filename port on the target. Use an expression transformation to calculate the filename, changing it for each fiscal year. You create the filename port while creating the target ports. Click the icon on the far right hand side on the...

I am not positive I get what you are saying. Are you asking how to reuse a workflow "command task" across multiple repositories? Or are you asking how to call a command task from outside using SOA?

The first message you posted had this: table1.attribute1 = ( lookup table2.attribute from table2 where table2.attribute = ( lookup table3.attribute from table3 where table3.flag = 1 ) ) Am I to understand that each lookup returns a single record or does table1.attribute1...

Sweet solution blom0344!

If you are using PC version 8 you can use a java transformation. Source the table with the list of xml files then have the java transform read the xml file and spit out the content in a port.

Can't you use two lookups and then filter the records going into the two tables? Is there something complicating this that I am not aware of?

Another method is to use the Unstructured Data transformation. If you have it, you will find "Unstructured Data" on the transformation list. It can extract everything or specific portions to an XML doc. Very cool stuff. I have used it to parse everything from word docs to EDI messages.