Inputfield in loadscript

[curiousfellow]

I use this script

Inputfield testfield;

Tablename:

Load *,

testfield;

SQL select

A,

B,

C,

D

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

[qliksus]

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
];

[Kushal_Chawda]

Is your testfield is included in SQL?

Inputfield testfield;

Tablename:

Load *;

SQL select

testfield

A,

B,

C,

D

From tablename;