Dynamic Data ID Mappings

[zwyne]

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