So, I'm trying to create a flow using this table:
What I need the flow to do is run through each "Profile" column, and filter for me everything that starts with "0" (and I will put the result of the filter into an output file, but that I know how to do). So in this example, I would need the row Profile 1/Type 3 and the row Profile 2/Type 2. My problem is that the number of profiles can (and will) increase with time, that's why I can't "hardcode" the same actions for each profile. The ideal output would be something like this (on another file):
Does anyone have any idea of how to do this dynamic loop? Any help is greatly appreciated. Thanks in advance!
Solved! Go to Solution.
Transpose Type is your key column.
Next filter
regex_match([value],"0.*")
if you're adding additional profiles later just make sure that dynamic/unknown fields are checked on your transpose.