Hi,
Sorry I get confused easily. I do not follow what I am looking at versus what you want.
You have 1-M rows.
Each row has 1-M columns
Each column value is either True or False
You want an HTML Table that has.. I guess, the 5 Colors as Columns and then for each row, put false in for all the false rows.
if its true, put true in, but in another table
So you would need to separate Arrays.
now depending on how you did this the easy way would be
Create Both arrays with a starting point of
["Blue", "Red", "Yellow", "Orange'. "Green"]
Now you would loop through your Records (I have no idea where your data is so I cannot tell you how)
For each Row, you would do an Append to Array 2 times.
In the first one you would something like this
["","","","",""]
Now inbetween the "" double quotes, you would add an expression.
The expression would do something like (and you would do it PER append array because one is for True and one is for False
So lets pretend it the True array
if(equals(thiscolumnofthiscurrentrow, "True", "True")
it would look like this in total
["if(equals(thiscolumnofthiscurrentrow, "True", "True")","if(equals(thiscolumnofthiscurrentrow, "True", "True")","if(equals(thiscolumnofthiscurrentrow, "True", "True")","if(equals(thiscolumnofthiscurrentrow, "True", "True")","if(equals(thiscolumnofthiscurrentrow, "True", "True")"]
Where each space between the "" would be the expression, and the change is the Column, remember it ONLY writes the string True if the current value IS True else it writes nothing
You would the exact same for the false array
When you are done looping, you now have 2 arrays
1 with all the row columns marked as True or nothing
and 1 with all the row columns marked as False or nothing
Now you can use the Create HTML Table action (twice)
to create Tables from the arrays, and each only shows False and or True but not mixed.
