How to join text data files ? Yes, I Know IT ! Ep 14
📂 Go to https://yesik.it/EP14 to download the files used in this video so you can practice on your own system.
The "join" command is a standard POSIX command (http://pubs.opengroup.org/onlinepubs/...) allowing you to merge two text files based on their content.
For each file, you define which field should serve as a key, and the join command will match the lines having the same values in the key field. Exactly like the JOIN SQL statement would do it on database tables.
When recording this video, I had two different categories of viewers in mind:
the Bash and scripting aficionados that are always eager to discover some powerful command
Novice SQL users that need to consolidate their understanding of the JOIN operation.
In less than 10 minutes you will learn all about the "join" command. For example, you will discover that, just like its SQL counterpart, the POSIX join command allows not only INNER joins, but also OUTER joins.
And if you don't know what I'm talking about... don't panic: all is explained in details in the video. So, watch it now!
#Join #Linux #Unix #Utility #POSIX #Database #CLI #CommandLine #CommandLineTool #YesIKnowIT