Hi I am trying to model purchasing behaviour in scidb. I have a list of customers with a set number of fields and no nulls. Each customer will have shopped a number of times over the year for different numbers of different items. So I have a csv file with a line for each time a customer shops and a list of items purchased and price paid. Items (including number of) and price vary each time they shop.
Sorts of questions are around male customers tend to shop at time X and purchase these items. People who shop and time Y tend to buy these items etc.
Coming from relational land I'm struggling to model this in scidb. Can I load a csv with a variable number of fields per row?