I would like to assign 6 variables from this DT.
Variable1 should be “9485293” if Type is “Forrude”
Variable2 should be 6044AGAMV1P if Type is “Forrude”
Variable3 should be the Type (Forrude)
Variable4 should be “9485299” if Type is “VAP”
Variable5 should be “Viskere” if Type is “VAP”
Variable6 should be the Type (VAP)
The issue is that there can more lines in the DT and therefore more Types to choose from.
I was wondering if a For Each Row could do the trick, but that overwrites the same variables as the previous row assigns.
could it perhaps be a series of if statements? perhaps like this
For each row with severals IF’s in sequence
If row contains “Forrude” Assign items to variables
if row contains “VAP” assign item to variables
Or what would the best approach be?