Hi
I am trying to merge table (two coloumn from source table to two column in lookup table), below error is getting
Formula.Firewall: Query 'SALESDATA' (step 'Merged Queries') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
Source Table having
GL Month
D01 Jan
D01 Jan
D02 Feb
D02 Jan
(contain duplicate records)
Lookup table Has
GL Month Type
D01 Jan S
D01 Feb S
D02 Jan S
D02 Feb N
D03 Jan NC
so on...
where i may be going wrong...
I am trying to merge table (two coloumn from source table to two column in lookup table), below error is getting
Formula.Firewall: Query 'SALESDATA' (step 'Merged Queries') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
Source Table having
GL Month
D01 Jan
D01 Jan
D02 Feb
D02 Jan
(contain duplicate records)
Lookup table Has
GL Month Type
D01 Jan S
D01 Feb S
D02 Jan S
D02 Feb N
D03 Jan NC
so on...
where i may be going wrong...