I am having a problem, I am trying to alias these fields as you can see here:
But I get this error:
Please can someone tell me what the issue is?
Hello Clever Anjos,
But isn't the case that you can't rename two fields to have the same name? That's what I want to do. I want [Expenditure Date], [Income Date] and [Payment Date] to each be given the field name Date.
You need to load a data from a defined source...
see my attached image for clarification
if you can send a sample data, it will help this analysis
You can try this:
Date([Expenditure Date] as Date
Drop table Expenditure;