Hello, Sorry for my stupid question. I am new in this topic!
I am playing around with a flight delay data set and I want to translate the abstract “flight number” column in my data set with the information about the plane type (boeing or airbus) to see which plane types are more often delayed. In another table I have a translation of flight numbers to plane types.
How can I merge these 2 sources so the flight number is “exchanged” with the plane type information?
If the info is in 2 different tables, then the standard approach is to use the Joiner node. It is beginner friendly as long as there is a column in each table with matching values. If you don’t have matching values to join together then we will need more info (preferably a sample of the data or a workflow) to help more.
Hello, one last question: Is it necessary that the columns got the same name for the inner join to work? I tried the Joiner node to match the FlightNum column and the Spalte1 column of the other dataset and I created an “empty node”. What could be the reason? (This time I also attached the datasets) plane data_for Plane identification prepared.xlsx (97.5 KB) flightdata sample_Export.xlsx (5.8 KB)
It looks like 1 table has just the numbers for flights and the other has a combination of numbers and letters. Try this in the String Manipulation node to remove the letters from the FlightNum column on the table that has them.
regexReplace($FlightNum$, “[^0-9]”, “”)
This uses Regex to replace any non-numbers with blank.
Make sure that the data types match afterwards for the Joiner node, or adjust the setting that allows for matching of different data types in the Joiner Configuration window.
I am sure I can manage it now.