Excel automation - Boolean

Help Activities
, , , , ,
1

Hi,

I have been using checkboxes in my ml skill and my excel file as been outputting it as a checked box and a unchecked box, I have the type as boolean on my taxonomy manager so we get a TRUE value if it ticked, I have logic in place that gets this done however I have over 50 checkboxes and I would have to repeat the logic 50 times. how can I improve this?

image
image806×650 16.9 KB

2

Hi @Aki1111

Inside the If activity After the assign activity give the continue activity to continue with the next iteration.

Hope it helps!!

3

Please elaborate because 1.2, 1.3, 1,4 , etc that needs this to changed in the excel based on the if condition, Is there anyway of making it a variable to go through file and make changes with 50 if statements.