One Star

Excel Sheet to JSON data transfer

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.
1 REPLY
Community Manager

Re: Excel Sheet to JSON data transfer

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
----------------------------------------------------------
Talend | Data Agility for Modern Business