An AWK array can be something like a lookup table, held in memory. You can use that lookup table for data operations on another file, and in this post I demonstrate reformatting and table joining.
Source: LXer – A muggle’s guide to AWK arrays: 3