topic Re: Problem with InputField Function in Script in QlikView

Problem with InputField Function in Script

Thu, 07 Nov 2013 16:46:24 GMT

Hi,

I am trying to use inputField in my Load script for 5 table.

I am not sure 2 table are fine and problem with 3 tables.

The two table that are good have all 0 in the inputfield column, but the 3 table

that are not working are having the sequence no. generated.

This is one on the having problem

INPUTFIELD [EntityType Threshold];
EM_ENTITY_TYPE:
LOAD
[Entity Type ID],
[Entity Type],
0 AS [EntityType Threshold]
Resident T_EM_ENTITY_TYPE;
Thanks,

Chris

Re: Problem with InputField Function in Script

Sat, 09 Nov 2013 11:58:37 GMT

COuld you attach your qvw file??

Re: Problem with InputField Function in Script

Tue, 19 Nov 2013 02:44:02 GMT

You should check to see if you add the input fields to the table as the very last step associated with any linked tables. I have found that you can have problems like you describe if the linking of the tables is done after the inputfields are added to the table. So simply do a left join after all tables are linked to the table you are adding the inputfields to.

instead of the following order:

Table A:

load link,

userfield1;

Table B:

load link

Try

Table A:

load link,

unique id,

* ;

Table B:

load link

left join (Table A)

load unigue id,

0 as Userfield

resident table A;