Excel Sheet to JSON data transfer

Anonymous — Fri, 24 Jul 2015 13:02:47 GMT

Hi,
I am new to Talend and ETL solutions.
I have excel sheets as follows.
structure of the single excel sheet as follows.
__________________________________
| A | B |
-----------------------------------------------
A1 | User name | user A |
----------------------------------------------
A2 |Age | 27 |
----------------------------------------------
A3 |Gender | M |
----------------------------------------------
I am required to create a JSON as follows from a single excel file.
{
UserName: "user a",
age: 27
gender: "m"
}
and repeat it to same process to all the other excel sheets and create json form each excel.
I was unable to find a method to do so.
Please suggest me an solution.

Re: Excel Sheet to JSON data transfer

Anonymous — Mon, 27 Jul 2015 10:45:06 GMT

Hi
First, you need to convert rows to columns, eg:
A;B
User name; userA
Age;27
Gender;M
becomes
user name;Age;Gender
userA;27;M
Refer to this article to learn how to finish this transformation.
Then, write a json string with tWriteJsonFields.
Best regards
Shong

topic Excel Sheet to JSON data transfer in Talend Studio

Excel Sheet to JSON data transfer

Re: Excel Sheet to JSON data transfer