Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have the following in my load script:
Now what I would like to do is to join the Count Basket Trans table to FCT BASKET TRN, but as soon as I do that, my counts differ.
The reason for joining the two together is to increase performance on the front-end.
Any help will be appreciated.
I am not sure what exactly you are trying to do, but if all you want to do is add a counter field with a value of 1 to the first table, then just join like this:
"FCT BASKET TRN":
LOAD ...
FROM ...;
Join ([FCT BASKET TRN])
LOAD 1 As "Count Basket Trans"
Autogenerate 1;
PS - please add things like scripts as text and not as images.