I have to split a single row with 3similar distinct fileds, lets say f1,f2,f3, into 3distinct rows with fields f and id (where id=1 if field is f1, id=2 if field is f2, id =3 if field is f3).
That is to say starting from a single row in my table I would like to load 10 distinct rows with an id number.
Example of initial row:
Customer_Id, Customer_Name, f1, f2, f3;
What I need is to obtain a table like this:
Customer_id, Customer_Name, id_field, f
with 3 different rows for each (Customer_Id, Customer_Name)
Thanks for the content of this thread, certainly helped me alot
I've also had some problems using CrossTable and haning today this has helped.
I've also discovered that when reading data from an xlsx that the colummn names need to be text not numeric when using CrossTable although they don't need to be if you do a simple LOAD!
