The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

How to decode json file in rapidminer

KanikaAg15KanikaAg15 Member Posts: 19 Learner II
in Help
Hi,
I am trying to decode an encoded xlsx file using base64 but I am not able to locate any operator to help with it in direct conversion. I have run a couple of scripts but none have helped me with the same. Any suggestions will be highly appreciated

Answers

  • rdesairdesai Employee-RapidMiner, RMResearcher, Member Posts: 15 RM Research
    HI Kanika, there is a operator called to  image to base64 in RapidMiner. You can use that to parse your excel file. Followed by short python script will hep you to solve the problem. So your process should look like this. 
  • KanikaAg15KanikaAg15 Member Posts: 19 Learner II
    @rdesai is there any other alternative than using the python script. Also the file is .xlsx and not an image.
  • rdesairdesai Employee-RapidMiner, RMResearcher, Member Posts: 15 RM Research
    That's fine. You can use .xlsx here. But there is no alternative to use without python. 
  • KanikaAg15KanikaAg15 Member Posts: 19 Learner II
    okay is it possible you help with the python script that we can use.
  • rdesairdesai Employee-RapidMiner, RMResearcher, Member Posts: 15 RM Research
    edited February 2023
    Yes, Here! 

    Thanks to @MarcoBarradas
  • KanikaAg15KanikaAg15 Member Posts: 19 Learner II
    edited February 2023
    @rdesai @MarcoBarradas
     thanks for all the help so far. One more question I have used java and groovy script and want the decoded array in the return statement to directly use in pipeline. But somehow both java and groovy are not returning any output. Is it possible to store the generated file as output from the script or we can store the variable value in SQL server. 
Sign In or Register to comment.