fieldvalue and fieldvalue count does not working

[ananyaghosh]

Hi,

I a using the below script:

[TmpSalesRep]:
load
"%Sales Posting Day Key",
[Sales Posting Amount USD] as SalesAmount,
[%Sales Rep Key] as AsOfSalesRepID
resident [Temp Table]
where
"%Posting Date Key" = '20170307' and "Sales Posting Amount USD">0;
Now the above table has 1307 records, but the below table generate only 607 records with all rows have '?' value.
[TmpSalesRep3]:
Load fieldvalue('AsOfSalesRepID',recno()) as SalesRepIDTmp
AUTOGENERATE fieldvaluecount('AsOfSalesRepID');

Please help me

[ananyaghosh]

yes

[sunny_talwar]

Cool , I am glad it worked out for you