Transpose fields based on condition

Hi,

I have a set of data in a format like the below screenshot.

Essentially I need the Region columns transposed to align with the rules. This is done by checking whether the field = TRUE. Any Regions with FALSE or [Null] should be ignored and I do not want to see them in the final data set. I am trying to create a list of rules, along with the regions that they apply to. This will ultimately be used as a reference table.

Equally if a rule has no regions = TRUE, then that rule needs to preferably have a "None" assigned to it, or otherwise be dropped from the final data (Rule 2 is an example of this).

Is this possible?

Transformation

Accepted answers

ponraj

Here is the sample workflow for your case. Hope this is helpful.

Workflow Results Results

Transpose fields based on condition.yxmd

danrh

I saw this one and wanted to see if I could do it in a single data line. So here's another option!

solution.yxmd

All comments

Ladarthure

Hi,

I would use a regular transpose and then use a filter with the test(s) you need to do.

ponraj

Here is the sample workflow for your case. Hope this is helpful.

Workflow Results Results

Transpose fields based on condition.yxmd

danrh

I saw this one and wanted to see if I could do it in a single data line. So here's another option!

solution.yxmd

bpretorius

@ponraj This works great! Thank you!

bpretorius

@danrh - This works great thank you! I am not sure I exactly follow what is happening in the Multi-Row Formula tool - do you mind sharing the logic behind what is happening there?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703