Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
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?
Best wishes,
Alison
If you want to rename a field use
RENAME <field> to <new name>;
Hi,
Load
[Payment Date] as Date - absent FROM
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.
Hello Andrey,
Sorry, what do you mean by that. What do the '-' and 'absent' mean?
Hello Cooke,
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
Regards
Hello Akpofure Enughwure,
I have now added the data source but I am still have the same problem. Any suggestion?
Thanks in advance.
Please share a sample data so I can check from my end
Hi,
Yes of course, here it is.
Hi Alison,
You can try this:
FinalExpenditure :
Load
[Expenditure Amount],
Date([Expenditure Date] as Date
Resident Expenditure;
Drop table Expenditure;
Thanks,
Arvind Patil