Normalize resource

[akariv]

Add ability to normalize a resource - i.e.

• extract a few columns out of a resource into a deduplicated 'lookup table' resource
• add proper cross indexes and pointers (i.e. replace extracted columns with the index of the
• create foreign key relationships between the two resources.

[rufuspollock]

@akariv can you give a bit more detail - i normally think of "normalize" as like "unpivot" cf #72

[akariv]

Yes - unpivoting is actually a process for denormalizing data.

Normalizing is the process of removing duplication, as can be read about here:
https://en.wikipedia.org/wiki/Database_normalization

[rufuspollock]

Got it and clear. Thanks 😄