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
Watch video How to join text data files ? Yes, I Know IT ! Ep 14 online without registration, duration hours minute second in high quality. This video was added by user Yes, I Know IT ! 19 August 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 612 once and liked it 29 people.