I have a problem where I need to combine information from a “header block” in a table with rows in the “bottom” part of the table.
The table state in the header part Flows in columns and state if these are mandatory or optional in areas.
The bottom part includes condition which needs to be excepted in the flows (with a number in which sequence they should be executed).
I have different sheets like this in each the number of Flows (N) is different.
I would like to get a list like the following, where for each condition which selected in the flow the information is given in which Area and Flow and status (Mandatory/Optional) it is used. The sequence number can be included in the resulting table, but mustn’t (As in the screenshot).
Currently I have no real idea how come to a solution, specially as the number of columns for flows are variable in the different input files. The header rows (Area types) are fix.
Any idea how to treat it is welcome, I thought about splitting it through filter criteria in two table but than had no clue how to combine later again and why to do with the table individually
The logic is to read a column. The Flow 1 consist out of the steps Condition 1, 2 and 3 (The number just give the sequence in which the steps/conditions need to be executed. And the Flows should be executed in the different marked areas.
Target is to create a list to get a list for each Condition in which flow, area and mandatory/option combination it is used. I hope I could explain it understandable.
I provided you two options, one in tabular format and another one was your request, I personally like the tabular format.
You need to change the Gather Transform in both branches for the Condition and Areas to include the additional data, as less will get cover up auto by already being selected, but the new ones need to be selected.
Currently you are set for 10 Conditions and 3 Flows.
Updated the solution to cater for 50 Flows, also added Stack transform, so that when you replace the clipboard with actual data file, the transforms stays intact.