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.
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
