Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
zwyne
Creator
Creator

Dynamic Data ID Mappings

Hi Experts,

PFA

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

Please assist

0 Replies