Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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);
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
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);