Records getting combine in salesforce output

mani1304 — Sat, 16 Nov 2024 01:29:16 GMT

Hi there,

I am using tsalesforceinput component in query mode and want to fetch records using the below query.

SELECT CreatedDate, LastModifiedDate, Id, FirstName, LastName, Contact_Type__c, Phone, Fax, Email,

MobilePhone, Pref_Comm_Method__c, Phone_Ext__c, OtherPhone, Primary_Specialty__c, Secondary_Specialty__c, Status__c, Department,AccountId,(SELECT Name from Contact_Addresses__r) FROM Contact

But the problem is that output for some records which have multiple records for the same id are combining in one records having semicolon.

for example, if for Id 100, inner query has 4 records, then all are getting merge into one records like 100|a;b;c;d, but I wantit to be in 4 records like 100|a, 100|b, 100|c, 100|d

Here pipe is the delimiter

Please suggest how to achieve it.

topic Records getting combine in salesforce output in Talend Studio

Records getting combine in salesforce output