-
join the result of a depivot operation warning
Hello, I'm new to RapidMiner so bear with me :) I'm trying to do a rather simple process in which I use de-pivot (aka "melt") an example set and then use the result example set in a join operation. The de-pivot works exactly as I'd expected but the follow up join does not find the newly created column which I'd like to use…
-
Future.Industry 2022
Igniting Digital Transformation Join the world’s brightest minds to explore and discuss trends, solutions, and breakthrough achievements that challenge the status quo and reimagine how technology can be used to drive enhanced processes and products. From big brand thought leaders to early-stage start-up entrepreneurs,…
-
add identifier attribute for joining datasets
data set A: a1,b1,c1a2,b2,c2 data set B:x1,y1,z1x2,y2,z2 right now I am manually adding a final row column of data after exporting; for which dataset the data came from ie: data set A: a1,b1,c1,setAa2,b2,c2,setA data set B:x1,y1,z1,setBx2,y2,z2,setB before joining them together, Im wondering if there is a way to do that…
-
(NEW USER) -- How to use the Join Operator?
I am working through the Tutorials section, specially the "Merging and Grouping" section. I'm at the "(3/6) Join the data" section. I can't seem to find the Join Operator that I want. I've tried using the available Join Operators (there are 6 of them), but none of them come with any parameters (by the looks of it), so I'm…
-
Different Join Result from Studio to Server
I'm working on joining two rather large datasets together. Due to their sizes, I will have to perform the join on the server. Testing in RMstudio with a fraction of the data from each dataset does what I expect, completing the join successfully. However, when I run the same process with the same test data on the server,…
-
Changing Data in Rapidminer
Hello everyone, I am currently working with rapidminer and I got a question for which i didnt find any helpful information yet. For preparing my data I have a huge Excel file which i uploaded in Rapidminer. Since I want to analyse the data I need some new rows which I would like to create in Rapidminer. For example I have…
-
Relational data indexed
I have three tables (for example) Sales table = Date, productID, qty, amount, customerIDCustomer table = CustomerID, First, Last, Phone, email, loyalty pointsProduct table = ProductID, origin, weight, lead time, price, aisle#, supplier, category How to connect these for analysis?
-
Altair HPC Summit 2021
Altair HPC Summit 2021 Discover Multi-dimensional HPC May 11 - 12, 2021 I Virtual Global Event Reserve your Virtual Seat Now Featuring Presentations From Are You Ready for Multi-dimensional HPC? At this year's Altair’s HPC Summit, experts managing and leveraging some of the world's leading HPC systems will share how…
-
Virtual ATCx Composites
AGENDA This conference is a one day event for two time zones - CET and PST. * December 2 at 9am - 3pm Central European Time (CET) * December 3 at 9am - 3pm Pacific Standard Time (PST) Altair is proud to bring together a line-up of its own and industry experts for this free-to-attend online event to demonstrate how to save…
-
How to do multiple Twitter search and join them together?
Hi guys, I need to do multiple Twitter search and sentiment analysis to compare each query. For example, I want to compare the sentiment among the different candidates. I learned from the community that I can use Loop Examples to save me some time: My question: Is there an easy way to join the ExampleSets above? I can save…
-
How to join multiple excel sheets to combine them into one cluster (k-means) ?
Hey there, I'm trying to join (in this example 2 but the purpose is to join a huge number of excels) some excel sheets with the join operator to cluster similar documents from different datasets. My problem is, that the join operator overwrites the datasets which are identical in their structure to that the exampleset that…
-
Process failed: Label Array must not contain duplicates
I encountered this when both my data sets have no duplicates before join. what should i do?
-
Number of Attributes After Join Operation
Hi everyone, After joining two datasets the Join Operator removes double attributes. However, I am seeing the removed attributes on the metadata popup window when I hover on the output node. I also see removed attributes in the list of Select Attributes Operator. Is this a bug or an intended result? I wonder If somebody…
-
No examples after joining
Hi I am working on an assignment but I have a problem. There are 2 datasets, the first has some flight information and the second has weather information. I want to predict whether a flight will depart with a delay of 15 minutes or more (using a decision tree). I have done the following: - Import flight data -- select…
-
Specific case for Joining multiple datasets
Hi everyboday, In a data science project I have recieved 4 cleaned datasets on an intersting topic healthy diet to protects ourselselves against Covid-19. I have already imported these 4 data sets in Rapidminer Studio. before I analyse them with machine learning, modelling and statistical preditions I would like to join…
-
I cannot find join operator in Rapidminer studio 9.6
Dear All I used to use join operator to create an excel file of prediction models, but now the previous models don't run as it cannot find Join operator. Do you know the equivalent of this in the new version? Regards. Mansour
-
how to append/join two extract bank micro
how to append/join two extract micro e.g. extract macro names are qurery and query1 query=sachin,abhay,ravi query1=om,john,clara I want result query2=sachin,abhay,ravi,om,john,clara
-
Need help on grouping the records and compare against other groups
I have a dataset with 2 columns PSR,TASK_TYPE. Here PSR is unique numbers. But there are many task types which can be repeated. Now I have applied a group by using aggregate operator. Now I want compare the PSR's among the task types, I don't want same PSR to be in all the task types. I just need that PSR be only in task…
-
Matching stock return dates (Mo-Fr) with sentiment (daily) - join two datasets
Dear community, I am doing a sentiment analysis on stock returns on the example of a specific company. Now I am looking for the easiest way to match my sentiment measures with the firm-specific stock prices. As Xetra is only open Monday through Friday with exception of national holidays, I want to average my sentiment…
-
Date importing in different time zones
My team and I sit in different time zones. I created a data set on our server where the first row reads Mar 1, 2019. Because I provided no time, it sets my time as midnight. My time zone is in Texas, CST. If I copy and paste that value into a notepad it comes in as: Fri Mar 01 00:00:00 CST 2019 My teammate sits in…
-
How to Join two unrelated data in RapidMiner ???
How to Join two unrelated data in RapidMiner ???
-
join object from different collection
Dear all, i made a process whiwh split two documents (in fonction on his column), the results is 2 collections in which I have a number of object (this number = the number of column), now I want to join two objects, one from the first collection and the other one from the other, I really need your help to do this. Thank's…
-
no key attribute list shown for Join in tutorial process
I follow Tutorial on Merging and Grouping within Get Started.
Under 3/6 Join the data I have:
- retrieved Products and Transactions
- selected Join and connected it with two data tables
- under 4. selected Edit List (of attributes) but no List was shown
What am I doing wrong?
-
How can I after I've split my dataset join them together again in the same order as befo
Hi people, How can I after I've split my dataset join them together again in the same order as before? Below is an example, I just want the ID to go from 1 to 150 again in a chronological order. But just sorting the ID doesn't work. Also, how can I change the order of attributes in the results? Thanks -Prentice
-
Comparing 2 datasets
How do I compare 2 data sets and display whats different. The tables have the same data but differ in column Names. I have attached my process below. Please help.