Help with adding a column

jsaint

• September 02, 2015 00:00

• Answered

Follow

This seems like a simple problem but I am new to CloverETL and have yet to find a way to make this work.

I have an output stream coming from an XML Writer with many records each consisting of a single string field.

I have an HTTPConnector which pulls a single string from a web service.

I would like to combine these such that each output record consists of the string from the web service and the xml data from the stream.

I have tried a Combine but this only adds the string to first record from the XMLWriter.

There is no join key, so I have been unable to use any of the joiners.

Short of writing out 2 files and using a bash script, is there any way to accomplish this?

Thanks,
Jason

• 

  Lukas Cholasta

  • September 04, 2015 13:14

  0

  Comment actions Permalink

  Dear Jason,
  
  If I understand your problem correctly then there are two possible ways to solve your situation.
  It depends on the version of CloverETL Designer you are using.
  
  

  1. Version 4.1.0-M1: there is a new component called 'CrossJoin' in this version. You can use it to join your single string from HTTPConnector with multiple strings from XMLWriter as it does not require any join key and simply joins everything from every input together. So the output would be each of your multiple strings with single string from HTTPConnector joined.
  
  2. Older versions: in this case you will have to use Reformat where you add some kind of identificator (key) to your strings (from both sources) and then use ExtMergeJoin to join them together. The result will be the same as in the first case.

  
  
  I hope this will help you.
  
  Best regards

Please sign in to leave a comment.