Why would the count differ

[Anonymous]

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.

[jonathandienst]

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.