Hello, I need to copy the actual value of one field in a variable.
load * inline [ salesman , qty paul , 10 peter , 50 Alan , 30
];
I put this values in a table
Now, if I select one Item in a table I would to copy the value of Salesman field I selected in the variable . In this way I could to use the variable also ina a SQL scrpt. How to do this?
if you create a variable vTest and put the value to field (=salesman) the variable will assume the field value when it is uniqely identified and null if it isn't
elsewhere if you want to have ever a value in variable you can use an aggragation value in variable (=Max(salesman))
