Thanks Rohan, this helps a lot. I was trying to get node names or key names using tFileInputJSON component in Talend but not able to extract the node/key names. For ex:- I have used "$.*~". In your scenario json query "$.results.books[*~]". Will this extract the node/key names ? It would be great if could help me out on this scenario? Thanks!
Sir would you please answer how to find relation among 20 tables of json which is inside csv file format , if there is any prerequisite skills for this would you please let me know because I found interesting working in talend but when I got project to find relation its really going over my head.
Need assistainct in interpreting a csv file. That's the easy part. However, a couple of the fields contain JSON data. I need to get this field out an then extract field from that JSON field. Can it be done?
Good effort. one question bro. If you go your video timeline 5.50; how if I want to get Book all nodes in one variable but scenario is same are yours. I mean {"rank" :1,"publisher" : "Atria","description" : "description here", "price" : "10", "title" : "title here", "auther" :"Fredrik"} want to get, respectively all array.
@@LearningwithRohan thanks for reply Rohan, I m trying since this morning. but couldn't achieve. Very strange.... In Pentaho same path is working but not working in Talend, don't know why.
Hi I am get the data to api(postman)source data in that data we have some columns in that one column we have some sub records in that sub records how to create and load data to data base can you help me
If in one of the json key becomes currenttitle or anyting which will have title word inside it how will we parse that key because in other keyvalue pairs tha key is named as title and what iam asking is if the key is changed to (anything)title than how will we Parse that json key as we have defined a schema for row and column inside the talend for json table row format
Sir how to do it if our json is not in json file, in my case I am getting json inside one table column. Is it possible to extract json from that column of type (String by default by talend ) and set particular field into the destination table by tMap ? is that possible !
You need to pull that db column and connect to jsonExtract component, you can extract the field directly from db table.. then it needs to be connected to tmap
![How To Extract Xml Data From File In Talend 🏽👉🏾 Talend Xml Parsing Check It Out! [2020]](http://i.ytimg.com/vi/bjSuP86GYh4/mqdefault.jpg)
![How To Extract Xml Data From File In Talend 🏽👉🏾 Talend Xml Parsing Check It Out! [2020]](/img/tr.png)
Very good explanation and easy to understand..
What an explanation
We are excepting more vedios on JSON and Xml files with different data
very nice, Explanation is too good
Checkout courses.talendpro.com
Brother Rohan, really appreciate your hard work and commitment in giving us valuable videos, I am learning from your videos :)
Thanks more coming soon
@@LearningwithRohan is Talend a free data integration tool?
I mean really free with no cost at all?
Great work Rohan, you videos helped me crack a lot of interviews with a few tricky questions....keep up the good work :)
Good to hear that Pavan 👍
Thanks Rohan, this is very helpful
You’re welcome, keep learning n sharing
nice video
Very good explanation, thanks for sharing !
You are welcome! Keep learning n growing
Great Video Rohan..I have a query, which is the preferred method of data input and why?
you showed us 3 methods
Hi download my mobile app from talendpro.com for few free resources!
Good Demo !!! Can you post videos on Talend Data Mapper - tHMap ?
Download my mobile app from talendpro.com
Sir can you explain about twritejsonfield component
hi, by when you will complete the course.. any tentative date?
Amarnath Chegu very soon in just couple of weeks. I’m getting you all the best possible content so hold tight 😊 Happy Learning
@@LearningwithRohan thanks for the reply.
Thanks Rohan, this helps a lot. I was trying to get node names or key names using tFileInputJSON component in Talend but not able to extract the node/key names. For ex:- I have used "$.*~". In your scenario json query "$.results.books[*~]". Will this extract the node/key names ? It would be great if could help me out on this scenario?
Thanks!
Sir would you please answer how to find relation among 20 tables of json which is inside csv file format , if there is any prerequisite skills for this would you please let me know because I found interesting working in talend but when I got project to find relation its really going over my head.
Need assistainct in interpreting a csv file. That's the easy part. However, a couple of the fields contain JSON data. I need to get this field out an then extract field from that JSON field. Can it be done?
u can still use that json contained column as the input to json extract component
@@LearningwithRohan thanks Rohan
Good effort. one question bro. If you go your video timeline 5.50; how if I want to get Book all nodes in one variable but scenario is same are yours. I mean {"rank" :1,"publisher" : "Atria","description" : "description here", "price" : "10", "title" : "title here", "auther" :"Fredrik"} want to get, respectively all array.
U can play around changing the loop elements to obtain desired results..
@@LearningwithRohan thanks for reply Rohan, I m trying since this morning. but couldn't achieve. Very strange.... In Pentaho same path is working but not working in Talend, don't know why.
@@asifshahzad51783rd method will help
Hi I am get the data to api(postman)source data in that data we have some columns in that one column we have some sub records in that sub records how to create and load data to data base can you help me
Hi pls check my other video on getting data from api..
if one of the title field becomes currenttitle than how will we pars this json
Give an example
If in one of the json key becomes currenttitle or anyting which will have title word inside it how will we parse that key because in other keyvalue pairs tha key is named as title and what iam asking is if the key is changed to (anything)title than how will we Parse that json key as we have defined a schema for row and column inside the talend for json table row format
Sir how to do it if our json is not in json file, in my case I am getting json inside one table column. Is it possible to extract json from that column of type (String by default by talend ) and set particular field into the destination table by tMap ? is that possible !
You need to pull that db column and connect to jsonExtract component, you can extract the field directly from db table.. then it needs to be connected to tmap
Hi Rohan,
Could you please provide us sample JSON files so that we can directly use it in our Talend jobs?