You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "Mani120998 (via GitHub)" <gi...@apache.org> on 2025/03/26 06:36:13 UTC
[I] [Task]: Apache hop (hop)
Mani120998 opened a new issue, #5074:
URL: https://github.com/apache/hop/issues/5074
### What needs to happen?
My doubt is related to apache hop.
"Data":[{"BranchName":"KLANG BRANCH","BranchCode":"MY0100001","Rates":[{"Country":"AUSTRALIA","Rate":"9.9000","Unit":"1","CurrencyCd":"AUD","CurrencyName":"AUSTRALIAN DOLLAR","FlagName":"Australia.png","ModifiedDate":"3/17/2025 2:44:06 PM"},{"Country":"BANGLADESH - BANK ACC.","Rate":"27.6200","Unit":"1","CurrencyCd":"BDT","CurrencyName":"BANGLADESH - BANK ACC.","FlagName":"Bangladesh.png","ModifiedDate":"3/4/2025 3:01:26 PM"},{"Country":"BANGLADESH - CASH PICK UP","Rate":"27.6200","Unit":"1","CurrencyCd":"BDT","CurrencyName":"BANGLADESH - CASH PICK UP","FlagName":"Bangladesh.png","ModifiedDate":"3/4/2025 3:01:26 PM"},{"Country":"BKASH (MOBILE WALLET)","Rate":"27.6200","Unit":"1","CurrencyCd":"BDT","CurrencyName":"BKASH (MOBILE WALLET)","FlagName":"Bkash.png","ModifiedDate":"3/4/2025 3:01:26 PM"},{"Country":"CHINA","Rate":"1.5509","Unit":"1","CurrencyCd":"CNY","CurrencyName":"CHINESE YUAN","FlagName":"China.png","ModifiedDate":"8/10/2023 3:39:53 PM"},{"Country":"HONG KONG","Rate":"
1.6700","Unit":"1","CurrencyCd":"HKD","CurrencyName":"HONG KONG DOLLAR","FlagName":"hk.png","ModifiedDate":"10/19/2022 1:34:17 PM"},{"Country":"INDONESIA","Rate":"3403.0200","Unit":"1","CurrencyCd":"IDR","CurrencyName":"INDONESIAN RUPIAH","FlagName":"Indonesia.png","ModifiedDate":"6/11/2024 2:10:18 PM"},{"Country":"INDIA","Rate":"18.5000","Unit":"1","CurrencyCd":"INR","CurrencyName":"INDIAN RUPEES","FlagName":"India.png","ModifiedDate":"10/18/2023 4:13:03 PM"},{"Country":"JAPAN","Rate":"27.2533","Unit":"1","CurrencyCd":"JPY","CurrencyName":"JAPAN YEN","FlagName":"jp.png","ModifiedDate":"3/11/2022 11:40:05 AM"},{"Country":"CAMBODIA","Rate":"0.2080","Unit":"1","CurrencyCd":"USD","CurrencyName":"CAMBODIA (US DOLLAR)","FlagName":"kh.png","ModifiedDate":"6/11/2024 1:37:13 PM"},{"Country":"SOUTH KOREA","Rate":"272.4929","Unit":"1","CurrencyCd":"KRW","CurrencyName":"SOUTH KOREAN WON","FlagName":"kr.png","ModifiedDate":"3/11/2022 11:39:24 AM"},{"Country":"SRI LANKA","Rate":"56.0000","Unit":
"1","CurrencyCd":"LKR","CurrencyName":"SRILANKAN RUPEE","FlagName":"Sri Lanka.png","ModifiedDate":"3/17/2025 2:49:46 PM"},{"Country":"MYANMAR","Rate":"479.5000","Unit":"1","CurrencyCd":"MMK","CurrencyName":"MYANMAR KYAT","FlagName":"Myanmar(Burma).png","ModifiedDate":"10/16/2024 12:31:14 PM"},{"Country":"NEPAL","Rate":"30.0000","Unit":"1","CurrencyCd":"NPR","CurrencyName":"NEPALESE RUPEES","FlagName":"Nepal.png","ModifiedDate":"10/25/2024 1:44:08 PM"},{"Country":"CITY EXPRESS (NEPALESE RUPEES)","Rate":"28.5000","Unit":"1","CurrencyCd":"NPR","CurrencyName":"CITY EXPRESS (NEPALESE RUPEES)","FlagName":"CityExpress.png","ModifiedDate":"9/23/2024 10:35:39 AM"},{"Country":"IPAY REMIT (NEPALESE RUPEES)","Rate":"31.4000","Unit":"1","CurrencyCd":"NPR","CurrencyName":"IPAY REMIT (NEPALESE RUPEES)","FlagName":"IPay.png","ModifiedDate":"2/18/2025 6:59:02 PM"},{"Country":"HIMALAYAN (NEPALESE RUPEES)","Rate":"28.5000","Unit":"1","CurrencyCd":"NPR","CurrencyName":"HIMALAYAN (NEPALESE RUPEES)","Fla
gName":"Himal.png","ModifiedDate":"9/23/2024 10:35:47 AM"},{"Country":"GME REMIT (NEPALESE RUPEES)","Rate":"28.5000","Unit":"1","CurrencyCd":"NPR","CurrencyName":"GME REMIT (NEPALESE RUPEES)","FlagName":"GME.png","ModifiedDate":"9/23/2024 10:35:43 AM"},{"Country":"PHILIPPINES","Rate":"12.4000","Unit":"1","CurrencyCd":"PHP","CurrencyName":"PHILIPPINE PESO","FlagName":"Philippines.png","ModifiedDate":"10/9/2024 10:39:49 AM"},{"Country":"PAKISTAN","Rate":"212.4500","Unit":"1","CurrencyCd":"PKR","CurrencyName":"PAKISTANI RUPEE","FlagName":"Pakistan.png","ModifiedDate":"9/6/2024 6:30:34 PM"},{"Country":"SINGAPORE","Rate":"0.3100","Unit":"1","CurrencyCd":"SGD","CurrencyName":"SINGAPORE DOLLAR","FlagName":"Singapore.png","ModifiedDate":"8/16/2024 11:16:37 AM"},{"Country":"THAILAND","Rate":"7.5500","Unit":"1","CurrencyCd":"THB","CurrencyName":"THAI BAHT","FlagName":"th.png","ModifiedDate":"12/10/2024 12:42:44 PM"},{"Country":"UNITED KINGDOM","Rate":"0.1789","Unit":"1","CurrencyCd":"GBP","Cu
rrencyName":"GREAT BRITAIN POUND","FlagName":"United Kingdom(Great Britain).png","ModifiedDate":"3/10/2022 11:34:24 AM"},{"Country":"UNITED STATES","Rate":"0.2381","Unit":"1","CurrencyCd":"USD","CurrencyName":"US DOLLAR","FlagName":"United States of America (USA).png","ModifiedDate":"6/21/2019 12:52:45 PM"},{"Country":"VIETNAM","Rate":"5385.0000","Unit":"1","CurrencyCd":"VND","CurrencyName":"VIETNAMESE DONG","FlagName":"Viet Nam.png","ModifiedDate":"10/17/2024 12:25:26 PM"}]}
This is my input data receiving from rest client transform, So goal is to iterate the json data based on branch name and branch code. consider branchname and code as parent, inside Rates json there are so many dictinories are there So I need to retrieve the data row by row and insert in the table. for eg: Inside rates json having 20 records means the same length I need to save in the table but branchname and code should be repeat for that 20 record why because of this, the rates array is belong to that particular branchname and code, like this more branch I will receive the same rules I need to follow.
So please provide me the correct transform to achieve this.
### Issue Priority
Priority: 1
### Issue Component
Component: Hop Gui
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Task]: Apache hop (hop)
Posted by "bamaer (via GitHub)" <gi...@apache.org>.
bamaer commented on issue #5074:
URL: https://github.com/apache/hop/issues/5074#issuecomment-2753451913
Kind of got triggered by this, turned out to be almost exactly the same as the sample I referred to earlier.
Remove the `.txt` extension at the end of the filename, and put your file in `${PROJECT_HOME}/input` or change the path for the first JSON Input transform.
[5074-nested-json.hpl.txt](https://github.com/user-attachments/files/19462216/5074-nested-json.hpl.txt)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Task]: Apache hop (hop)
Posted by "bamaer (via GitHub)" <gi...@apache.org>.
bamaer commented on issue #5074:
URL: https://github.com/apache/hop/issues/5074#issuecomment-2753426479
Closing because this not an issue/task (and certainly not a P1).
Have a look at `transforms/json-input-nested-elements.hpl` in the samples project, and feel free to create a discussion for this.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Task]: Apache hop (hop)
Posted by "bamaer (via GitHub)" <gi...@apache.org>.
bamaer closed issue #5074: [Task]: Apache hop
URL: https://github.com/apache/hop/issues/5074
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org