Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] seperating json data into different columns

hi, i have been trying to seperate the received json file data into different columns, but i cannot do it, i have used 'twritejsonfield' but the columns are getting the name of the column also..i just want the values to get loaded..some one please help..

This is what i have done so far..
Labels (3)
17 Replies
Anonymous
Not applicable
Author

as far as I know you have to code encode/decode by yourself.
use org.apache.commons.codec.binary.Base64 library for that.
regards
Anonymous
Not applicable
Author

i tried using this but its not supported in talend..so i downloaded a jar file...am not sure in what path it should be copied so that it supports it.....or is there any other way...
kindly help...
Anonymous
Not applicable
Author

use tLoadLibrary ... to load .jar:
https://help.talend.com/search/all?query=tLibraryLoad&content-lang=en
then in a tJavaRow , use the encode/decode method with the string you want to manage as parameter.
Anonymous
Not applicable
Author

have a look at thsi exchange component (not maintained  but it could work)
http://www.talendforge.org/exchange/tos/extension_view.php?eid=142
Anonymous
Not applicable
Author

 it has been prompting me to download "ostermillerutils_1_07_00.jar" file, the download option is not working....when i tried to download it externally and load it its not taking and the error is coming to download the file....how to sort out please help
.....
Anonymous
Not applicable
Author

try using tReplace it works for me 0683p000009MACn.png
Anonymous
Not applicable
Author

i would like to truncate a oracle table at a interval of evry 7 days...and want that job to run automatically.....can someone help please!!!!
Anonymous
Not applicable
Author

Hi sailesh1809,
Please open a new topic for your issue or edit the related forum to add your requirment in forum : https://community.talend.com/t5/Design-and-Development/delete-a-oracle-table-at-regular-interval-of-....
In that way, other community users have a chance to see your issue and give a hand to you.
The current topic is not related to your issue.
Many thanks.
Best regards
Sabrina