Simple END USER KEY without group by clause is working fine for same table.
load [End User Key] ,
Flag1 as F1,
Flag2 as F2,
Flag3 as F3
But when i am pulling the same column (End user key) in group by,Its giving an error : Field not found.
I think there is some syntax issue with group by.
Thanks jagan for quick reply.
I am copying the same field used in tmp1_Transactions.So case mismatch issue is not there .
I cant attach whole script but i can show you sample of tmp1_Transactions:
text([Article No.]) as %KEY_ITEM,
if([Invoice Date]='1900-01-01','',[Invoiced Date]) as [Invoiced Date],
if(openorder=1,'Open','Invoiced')) as [Order status],
num(OrderCompany)&'|'& text(applymap('MAP_ITEM_PG',text([Article No.]),0)) as KEY_SCOPE_DISCOUNT,
Applymap('MAP_PARTTYPE_CURR',text([Article No.]),0) as Local_Curr,
Applymap('MAK',[Order No.],'N/A') as [End User Key],
text([Article No.]) as KeyScope,