combining data in excel sheet in multiple rows into a single row

One Star

combining data in excel sheet in multiple rows into a single row

Hello all,

I have to build a job where the data is in the excel sheet as follows

 

id

vaultstatusaction

OQ3000000000Q42

Pending FDD Review

OQ3000000000Q43

Pending FDD Review

OQ3000000000Q44

Pending FDD Review

OQ3000000000Q45

Pending FDD Review

OQ3000000000O53

api/v18.1/vobjects/disclosure__c/OQ3000000000O53/actions/Objectlifecyclestateuseraction.disclosure__c.change_state_to_accepted_without_fdd_rev__c

OQ3000000000O54

api/v18.1/vobjects/disclosure__c/OQ3000000000O54/actions/Objectlifecyclestateuseraction.disclosure__c.change_state_to_accepted_without_fdd_rev__c

OQ3000000000O55

api/v18.1/vobjects/disclosure__c/OQ3000000000O55/actions/Objectlifecyclestateuseraction.disclosure__c.change_state_to_accepted_without_fdd_rev__c

 

the output needed is

 

 

 

url

idlist

api/v18.1/vobjects/disclosure__c/actions/Objectlifecyclestateuseraction.disclosure__c.change_state_to_accepted_without_fdd_rev__c "

 

"id = OQ3000000000Q42,OQ3000000000Q43,OQ3000000000Q45"

so I have to get 100 ids in a single row in the second column separated by a comma. Can anyone help me with this?

 

Thirteen Stars

Re: combining data in excel sheet in multiple rows into a single row

@Chaithra_kb,are you looking for the below one?

Untitled.pngUntitled.pngUntitled.pngUntitled.png

Manohar B

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.