Hi
Is this a bug? Just reporting to be sure. Version 9.3.1
Two queries, A and B with a Merge transform.
A: select date_trunc(‘day’,b.date) as “time”, … from regions a, regions_usage_live b WHERE a.date = b.date group by date_trunc(‘day’,b.date)
B: select date_trunc(‘day’,b.date) as “time”, … from regions_live a, regions_usage_live b WHERE a.date = b.date group by date_trunc(‘day’,b.date)
Merge debug:
A: 0:Object
name:“Time”
type:“time”
B:
0:Object
name:“time”
type:“time”
A gets capital “T” on “Time”.
Solved by changing B to ‘as “Time”’