This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have bit of a situation here. From the attached file, I would to create Dynamic Data ID Mapping based on the fields
DYNAMIC_FIELD_ID and DYNAMIC_FIELD_VALUE to create the New_Field_Name=Responsible Sub Business Unit. So in essence what I want to is something similar to this:
Map_Dynamic_FieldValue: LOAD [Dynamic Field ID], Value FROM [Static Files\Sample.xlsx] (ooxml, embedded labels, table is [Data]);
LET vCount=NoOfRows('Map_Dynamic_FieldValue')-1; FOR a = 0 to $(vCount) LET vDynamicID=peek('Dynamic Field ID',$(a),'Map_Dynamic_FieldValue'); LET vFieldValue=peek('Value',$(a),'Map_Dynamic_FieldValue');
I will then join it to some other table as
LEFT JOIN(TEMPAudit) DynamicFieldData: LOAD [Aud ID] AS [TEMP ID], [Dynamic Field Source Option Value] as [Audit $(vFieldValue)] FROM [..\QVD\TEMP\DynamicData_Value.qvd] (qvd) WHERE [Dynamic Field ID]=$(vDynamicID); NEXT; DROP TABLE Map_Dynamic_FieldValue;
My problem in this instance is that the field Value is has different Dynamic Field ID