Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Missing Field Value

Hello Everyone,

I am having a problem, I am trying to alias these fields as you can see here:

Screenshot (15).png

But I get this error:

Screenshot (16).png

Please can someone tell me what the issue is?

Best wishes,

Alison

16 Replies
Employee
Employee

Re: Missing Field Value

If you want to rename a field use

RENAME <field> to <new name>;

ahaahaaha
Honored Contributor

Re: Missing Field Value

Hi,

Load

[Payment Date] as Date - absent FROM

Not applicable

Re: Missing Field Value

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.

Not applicable

Re: Missing Field Value

Hello Andrey,

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

akpofureenughwu
Contributor II

Re: Missing Field Value

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

Not applicable

Re: Missing Field Value

Hello Akpofure Enughwure,

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

Thanks in advance.

akpofureenughwu
Contributor II

Re: Missing Field Value

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

Not applicable

Re: Missing Field Value

Hi,

Yes of course, here it is.

arvind_patil
Valued Contributor II

Re: Missing Field Value

Hi Alison,

You can try this:

FinalExpenditure :

Load

  [Expenditure Amount],

  Date([Expenditure Date] as Date

Resident Expenditure;

Drop table Expenditure;



Thanks,

Arvind Patil