Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Inputfields and SR3

SR3 changed the way inputfields work.  I just reloaded a v9 inputfields example from Qlikview in v10 SR3 and the functionality was lost.  I'm confused on how to achieve the same functionality.  I posed this question at the bottom of my earlier post here: http://community.qlik.com/message/131512

To add an inputfield to a table, you used to be able to declare a field an inputfield near the top of the script then do Load *, [InputField] Resident TableName.  Not so anymore.  What is the new best practice here?

Labels (1)
1 Solution

Accepted Solutions
Not applicable
Author

It appears that the new best practice is a workaround where you must load from a different data source, like a qvd, rather than do a resident load.  So when you are at the point where you would like to add an inputfield to your table, store the table in a QVD, then load that QVD with the additional inputfield.  For example, something like:

INPUTFIELD FieldName;

Data:

LOAD * INLINE [

Name, Group

Adam, X

Andrew, X

Amy, Y

];

STORE Data into Data.qvd;

drop table Data;

LOAD *, '' AS FieldName

FROM Data.qvd(qvd);

View solution in original post

2 Replies
erichshiino
Partner - Master
Partner - Master

Hi, Shanrahan

We discussed some cases in this thread, please check if it can help, if please describe you problem a bit more or post your script.

http://community.qlik.com/message/140787#140787

Regards,

Erich

Not applicable
Author

It appears that the new best practice is a workaround where you must load from a different data source, like a qvd, rather than do a resident load.  So when you are at the point where you would like to add an inputfield to your table, store the table in a QVD, then load that QVD with the additional inputfield.  For example, something like:

INPUTFIELD FieldName;

Data:

LOAD * INLINE [

Name, Group

Adam, X

Andrew, X

Amy, Y

];

STORE Data into Data.qvd;

drop table Data;

LOAD *, '' AS FieldName

FROM Data.qvd(qvd);