Creating a cross table / creating missing rows in load script
I have a set of data relating to currency conversion rates to one currency - my sample data is as follows (where all currencies map to USD)
LOAD * INLINE
What I am looking for is a way to map the currenices directly to each other without having to go through USD - in this sample data I would want to see that EUR to AUD gives a conversion rate of 1.267 (the EUR to USD rate / AUD to USD rate). This would then be repeated for all other currency combinations so that all source / target pairs exist within the data.
I would like to be able to create all permutations within the LOAD script rather than within charts if this is at all possible.