topic Re: Inputfield in loadscript in QlikView

Inputfield in loadscript

curiousfellow — Thu, 21 Apr 2016 14:20:46 GMT

I use this script

Inputfield testfield;

Tablename:

Load *,

testfield;

SQL select

From tablename;

I get an error message field <testfield> unknown and I do not understand why.

Changing the order (load testfield, * ) does not help

Your help is appreciated

Re: Inputfield in loadscript

florentina_doga — Thu, 21 Apr 2016 14:25:40 GMT

try this

Tablename:

Load *

SQL select

From tablename;

Inputfield testfield;

noconcatenate

table2:

load *, testfield

resident Tablename;

drop table Tablename

hope this help.

Re: Inputfield in loadscript

marcus_sommer — Thu, 21 Apr 2016 14:28:31 GMT

Your inputfield must be a real field either from the sql or created new with an alias:

Inputfield testfield;

Tablename:

Load *,

0 as testfield;

SQL select

testfield

From tablename;

- Marcus

Re: Inputfield in loadscript

sunny_talwar — Thu, 21 Apr 2016 14:28:59 GMT

May be try this:

Inputfield testfield;

Tablename:

LOAD *,

0 as testfield;

SQL select

From tablename;

Re: Inputfield in loadscript

tamilarasu — Thu, 21 Apr 2016 15:12:40 GMT

You can also try,

INPUTFIELD testfield;

Tablename:

SQL select

'' as testfield

From tablename;

Re: Inputfield in loadscript

richard_chilvers — Thu, 28 Apr 2016 07:53:12 GMT

Hi Marcus

I have never used INPUTFIELD, but it looks handy, so I thought I'd do some testing.

This is my script, which seems very similar to yours, but produces an error (Duplicate Keys). I must be misunderstanding, but could you explain ?

Thanks

INPUTFIELD Quantity;
LOAD *, 0 AS Quantity
INLINE [
F1, Quantity1
1, 0
3, 0
1, 0
23, 0
15, 0
];

Re: Inputfield in loadscript

marcus_sommer — Thu, 28 Apr 2016 08:14:34 GMT

The assignment from a inputfield value within the table (not absolutely sure but I believe within the whole datamodel) must be absolutely unique which is not given in your example (I have marked it with a bigger font):

INPUTFIELD Quantity;
LOAD *, 0 AS Quantity
INLINE [
F1, Quantity1
1, 0
3, 0
1, 0
23, 0
15, 0
];

- Marcus

Re: Inputfield in loadscript

richard_chilvers — Thu, 28 Apr 2016 08:18:52 GMT

Ah, OK Marcus, thanks for your prompt response.

Re: Inputfield in loadscript

curiousfellow — Thu, 28 Apr 2016 09:20:31 GMT

Thank you all for your answer. As soon as I return from holidays I will try to look further

Re: Inputfield in loadscript

Mahamed_Qlik — Thu, 28 Apr 2016 11:55:42 GMT

Hi Curiousfellow,

Before commentiong, I would like to know, does you table has field named as testfield ?

Regards,

Mahamed

Re: Inputfield in loadscript

qliksus — Fri, 29 Apr 2016 09:01:19 GMT

The Data should be unique for the combination you load as this is not in your case you can always use distinct and avoid the duplicate values

INPUTFIELD Quantity;
LOAD distinct *, 0 AS Quantity
INLINE [
F1, Quantity1
1, 0
3, 0
1, 0
23, 0
15, 0
];

Re: Inputfield in loadscript

Kushal_Chawda — Fri, 29 Apr 2016 09:03:58 GMT

Is your testfield is included in SQL?

Inputfield testfield;

Tablename:

Load *;

SQL select

testfield

From tablename;