Problem with InputField Function in Script

[#1]

    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

[#2]

COuld you attach your qvw file??

[#3]

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;