I am getting an error field not found- End User Key while applying Group by.
Note : I already have that column in Fact table (Fact) coming from tmp1_trans table.
_____________________________________________________________ Fact: LOAD *, If([Invoiced Date]>=SDB1 and [Invoiced Date]<=EDB1,1,0) as Flag1, If([Invoiced Date]>=SDB2 and [Invoiced Date]<=EDB2,1,0) as Flag2, If([Invoiced Date]>=SDB3 and [Invoiced Date]<=EDB3,1,0) as Flag3
Did you used any Qualify statement in your script? Check the column name in Table viewer whether it is [End User Key] or any TableName.[End User Key]? If it is TableName.[End User Key] then use this as column name.