topic Re: Export multple values in one field in Talend Studio

Export multple values in one field

ars — Sat, 16 Nov 2024 09:14:41 GMT

Hi all,

I need to export a csv file that will consists of 4 fields, separered by "|" character.

But one of them must be contain multiple values, separated by ";" character.

For example, there will be 4 fields : FieldA, FieldB, FieldC, FieldD

I need to export records like this format:

|1|AAA|COMPONENT1;COMPONENT2;COMPONENT3|USER1

|2|BBB|COMPONENT1;COMPONENT2|USER2

|3|CCC|COMPONENT1;COMPONENT2;COMPONENT3;COMPONENT4;|USER3

|4|DDD|COMPONENT1;|USER4

Is there any way (component or code) to do that ? To "combine" multiple values into one field (FieldC) ?

Thank you in advance,

Ars

Anonymous — Thu, 28 Sep 2017 10:58:18 GMT

ars — Thu, 28 Sep 2017 11:36:42 GMT

Dear rhall_2_0,

Yes !!! This is it !!!

Perfect - thank you very much for your reply.

Regards,

Ars

SachinD — Thu, 28 Sep 2017 11:46:52 GMT

HI,

Input

output

col1|col2|col3|col4

1 |AAA |COMPONENT1;COMPONENT2;COMPONENT3|USER1
2 |BBB |COMPONENT1;COMPONENT2 |USER2

Anonymous — Thu, 28 Sep 2017 11:59:58 GMT

No problem. However you appear to have accepted your thank you note as the accepted solution.

ars — Thu, 28 Sep 2017 12:35:02 GMT

Sorry, my mistake !!!

I fixed it

Regards,

ars — Thu, 28 Sep 2017 12:36:42 GMT

Dear sachinddhake,

Thank you for your contribution - especially because you spent time in order to reproduce my requirement !!!

Best regards,

Ars