Just when I am finishing with a very time consuming project I'm now told my vertical data has to be horizontal. Oh, and did I mention it has to be ready by tomorrow noon...HELP! Here's what I got, 4 columns of data, column 1 is an unique identifier for a recipe, column 2 are the ingredients, column 3 is the ingredient amount, column 4 is an assigned ingredient code.
Rcode Ingrdt Serv Ingrdt code
R-1 eggs .0010 35
milk .0030 22
R-2 salt .0001 07
eggs .0005 35
flour .0016 100
There are about 275 recipes and the total number of ingredients are 1200. Now I'm told by the db folks that the data from each recipe has to be set up horizontally in this manner:
Rcode SVR#1 IC SVR#2 IC SVR#3 IC
R-1 .0010 35 .0030 22
R-2 .0001 07 .0005 35 .0016 100
Listed this way a recipe can have up to 10 ingredients (SVR#'s).
Could you possibly suggest a way in which I can acomplish this task without having to do so line by line. I will appreciate any help you have to offer, thank you.
Harriett
This message was edited by harriettb on 2002-10-15 00:24
This message was edited by harriettb on 2002-10-15 00:25
Rcode Ingrdt Serv Ingrdt code
R-1 eggs .0010 35
milk .0030 22
R-2 salt .0001 07
eggs .0005 35
flour .0016 100
There are about 275 recipes and the total number of ingredients are 1200. Now I'm told by the db folks that the data from each recipe has to be set up horizontally in this manner:
Rcode SVR#1 IC SVR#2 IC SVR#3 IC
R-1 .0010 35 .0030 22
R-2 .0001 07 .0005 35 .0016 100
Listed this way a recipe can have up to 10 ingredients (SVR#'s).
Could you possibly suggest a way in which I can acomplish this task without having to do so line by line. I will appreciate any help you have to offer, thank you.
Harriett
This message was edited by harriettb on 2002-10-15 00:24
This message was edited by harriettb on 2002-10-15 00:25