Yes, I know
How to Join Text Data Files?

You probably know I’m a Bash and shell scripting fan. But I really like databases too. And as such, I couldn’t have missed the join command to merge two text data files!

 Get the support materialCheck your mailbox for the link!  View on YouTube 

How to Join Text Data Files?

The join command is a standard POSIX command 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.

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!

How can I take the most of this video?

I encourage you to download the files used on the video so you will be able to try the same commands as me on your own system.

The link above will allow you to download a gzipped tar archive of the files used in the video. To extract the content of that archive on your system, you can use the command:

    tar xzf Yes_I_Know_IT-Ep14.tar.gz

What is the target audience?

Being at the conjunction of two of my favorite topics, I put a lot of efforts in this video to make it suitable for two different categories of viewers:

  • 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.

This video is pretty self-contained. And only require very basic skills in using the terminal emulator and a shell.