I am trying to filter datatable and write to excel in a structured way.
My issue is in the referencing in the filters & counters that inform the referencing for the loop. Please the two pictures below, pic 1 = DT1, pic 2 = DT2
I would like to filter DT1 based on the values in DT2 but am unsure of the referencing. So my question is 2 fold.
- What would the referencing look like to filter DT1. For example, “FormResponseID” = DT2(B2), “FormFieldID” = DT2(C2)?
- Second, if I was to add this to loop for each row, how would I reference within the filter to know which row to reference back to? For example, filter for 4th loop should be filtering “FormReponseID” by DT2(B4) = 101, “FormFieldID” by DT2(C4) = 718?
Thank you all!