dev_bi
dev_bi

Reputation: 11

From CSV to tContextLoad

I have a CSV parameter file :

enter image description here

And a job talend where I’m supposed to get this data back for loading into contexts :

enter image description here

But I get => tContextLoad_3 set key "First;Last" with value "Olivia;Anderson".

I would like to get something like => tContextLoad_3 set key "First" with value "Olivia;Amelia;Ava;Isabella" or "Olivia,Amelia,Ava,Isabella"...

I specify, I cannot change the format of my csv configuration file.

I tried to change the tfileinputdelimited several times but I can’t, Do you have any solutions ?

Upvotes: 0

Views: 184

Answers (1)

lke
lke

Reputation: 83

You can use tDenormalize, which is to denormalize one column in a delimited file.

enter image description here

Upvotes: 1

Related Questions