topic Re: Use of Talend Data Mapper in Talend Studio

Use of Talend Data Mapper

Anonymous — Sat, 16 Nov 2024 10:55:50 GMT

Hi, I have a usecase where I have to convert csv data to JSON, please see below the problem :

field1;field2;field3
1;;3

The expected result is :

{
	"element": 
}

I honestly have absolutely no idea how to answer that need, seems like something the TDM would do quite easily, but don't know how.
If you have any question about that feel free to ask.
Thank you very much for your help,
PS: I'm running a version of Talend Studio for Cloud with Data Quality 6.0.1
Simon B

Re: Use of Talend Data Mapper

Anonymous — Fri, 27 Nov 2015 15:41:49 GMT

Sorry => I may have omitted to say that I cannot just normalize my input data because I have multiple cases of that on my file... A complete example would be

field1;field2;field3;value1;value2;value3;value4;tagList
1;;3;"hello";"world";"!";"!";"a,b,c,d"

And the result :

{
	"element": ,
	"value": ,
	"tags": 
}

Re: Use of Talend Data Mapper

Anonymous — Mon, 30 Nov 2015 03:43:15 GMT

Hi,
Do you want to use tHap to convert csv data to JSON?
Here is a component TalendHelpCenter:tWriteJSONField which transforms the incoming data into JSON fields.
Please take a look at the related scenarios to learn how to use it.
Best regards
Sabrina

Re: Use of Talend Data Mapper

Anonymous — Wed, 09 Dec 2015 14:08:55 GMT

Hi,
I knew about this component but I can't use it easily in that case because I have to split every part of my input schema (and generate a key for each line) then use one tWriteJsonField for each part of the input schema to create the different arrays, write those in a file, then join every file I created and join them and use a last tWriteJsonField to create my global Json file... It's a real pain, but apparently I had no choice...

Hope that helps,
Simon B

Re: Use of Talend Data Mapper

Anonymous — Thu, 10 Dec 2015 05:05:45 GMT

Hi Sonam,
Does your input structure always fixed or it has variable schema? based on that we may suggest better.

Re: Use of Talend Data Mapper

Anonymous — Thu, 10 Dec 2015 09:12:23 GMT

Hi,
I don't know who Sonam is but on my side the input structure is dynamic, hence the use of a tExtractDynamicFields
Thanks,