Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
im having an issue with my 'for each loop'. basically i need this loop to loop through another table, copy all the records that have a PROTOCOL_ID ending in 'A', and insert them into a new table. I have loaded the exact table structure as in the other table, with the only amendment being that i need the FLAG column to now populate with 1, whereas in the other table its NULL. this script is in the Execute Layer of my QV app. could someone please advise as to why the following script is having an issue:
for each PROTOCOL_ID in OTHER_TABLE
NEW_TABLE:
load
PROTOCOL_ID,
COUNTRY,
Date(MONTH, 'DD-MMM-YYYY') as MONTH,
num(AMOUNT) as AMOUNT,
1 AS FLAG
resident OTHER_TABLE
where right(PROTOCOL_ID, 1) = 'A';
NEXT