Skip to Content
0
May 27, 2016 at 06:43 AM

Solution required for one ETL scenario in BODS

507 Views

Hi

Can anyone help me in providing solution for the below scenario.

We have source data like this.

CountryCityIndiaHyderabad India BangaloreIndiaMumbaiUSASanjoseUSANew yorkUSABostonUSA Los angeles

Now, we want output like below.

CountryCityIndiaHyderabad,Bangalore,MumbaiUSASanose,New york,Boston,Los angeles

Can any one help us for this scenario with detailed steps/logic we need to implemented to achieve the above output.

Thanks,

Ravi kiran