topic How do I link an inline load to a table to use as input fields in QlikView

How do I link an inline load to a table to use as input fields

Tue, 09 Feb 2010 15:43:35 GMT

Hi,

I am trying to use an inline load to create inout fields, but I do not know how to map against my table with the data in. The inline load is additional fields required for input against the main table. eg

Table A

Division,

Person,

Appointment Date

I want to be able to add the following as input fields but they are not in Table A.

Inputfield Cancelled;

Inputfield Comments;

Inputfield Reason;

I need these to be a line for line match in Table A. So if there are 50 lines in Table A, I need to be able to have 50 lines I can use the input fields against.

Thanks 🙂

How do I link an inline load to a table to use as input fields

disqr_rm — Tue, 09 Feb 2010 15:48:55 GMT

Something like this should work:

Inputfield Cancelled;
Inputfield Comments;
Inputfield Reason;

load 'F1' & recno() as Division,
'F2' & recno() as Person,
'F3' & recno() as [Appointment Date],
'' as Cancelled,
'' as Comments,
'' as Reason
autogenerate 50;

How do I link an inline load to a table to use as input fields

Tue, 09 Feb 2010 16:29:08 GMT

Thank-you.

That worked.