When looping thru LOAD statement can I reuse a column? I need to so I can build a key. Source is on the web so the relation is a click on a link.
Some pseudo code to explain: start loop 1 LOAD A,B,C from source1 start loop 2 LOAD A,D,E from source2 A in loop 2 should come from loop 1 The two load becomes two tables.
I would first try to split your pString into appropriate fields. Honestly, I don't know what these fields would be. I had a short look at the web sites and try to figure out how we could link the tables based on what information pieces, but no luck up to now.
I remember that you posted a question about splitting up something that looked like pString a few weeks ago, have you succeeded to apply your solution from that post to this application?
Could you tell us at what piece of information we need to look? What is making up a team / player? Or what would you like to analyze in detail?
I am leaving office now, not sure if I have the chance to work on that for the next days, but I think any information might help also others to help you.
in the data there are no way of linking. Maybe if we could make Date a variable from Games and reuse that in Player (together with Season). Splitting of the the string is in progress.
