Missing Field Value

[#1]

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

[Clever_Anjos]

If you want to rename a field use

RENAME <field> to <new name>;

[ahaahaaha]

Hi,

Load

[Payment Date] as Date - absent FROM

[#4]

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.

[#5]

Hello Andrey,

Sorry, what do you mean by that. What do the '-' and 'absent' mean?

[akpofureenughwu]

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

[#7]

Hello Akpofure Enughwure,

I have now added the data source but I am still have the same problem. Any suggestion?

Thanks in advance.

[akpofureenughwu]

Please share a sample data so I can check from my end

[#9]

Hi,

Yes of course, here it is.

[arvind_patil]

Hi Alison,

You can try this:

FinalExpenditure :

Load

  [Expenditure Amount],

  Date([Expenditure Date] as Date

Resident Expenditure;

Drop table Expenditure;

Thanks,

Arvind Patil