Clear the missing field in the table

[SGK_TS]

Hi Community,

I would like to ask if there is any way to clear the missing field in the table as per screenshot below . Reason being it is missing due to certain data changes every day , some times with in same day it will be like, Day :1 our staff may work 6am to 10pm,  day 2 may be 9am to 6pm.  When I run with out any table rules the output was correct however if I include table rules then Iam getting error below 

[Christina_H]

Are the column rules the same for all time columns?  If you exclude all the time columns you can set the rules on Dynamic or Unknown Fields.  Then when you re-add the time columns, whichever ones are present should pick up the rules with no errors.

[SGK_TS]

Hi Christina,

Thanks for your response.  I am just trying to color in red  each column in each hour when the count is less than 4 basically .. kindly help me how to arrive this. am getting the error , could you please check.

[CoG]

Using this formula on Dynamic/Unknown Fields which is first attached to a table with trash column:

IF REGEX_Match([_CurrentFieldName_], "\d:\d{2}") THEN ToNumber([_CurrentField_])<=4 ELSE 0 ENDIF

If you delete the connection to the Table Tool and instead connect it to your table, it should work.

[SGK_TS]

Hi  AndrewDMerrill

Thanks for your response , look like  your flow chat can resolve my issue but I am getting below error , could you please guide me 

 Error: Parse Error at char(n): Formula: tried to apply string operator to numeric value (REGEX MATCH )

My data will be like below 

ID	Name	9AM	10AM	11AM	12PM	1PM
123	KSK	8	16	3	15
456	DD	6	44	4	18	12
789	IIO	4	62	4	0	13
125	PKO	2	32	4	20	14
String Data Type	String Data Type	Double Data Type	Double Data Type	Double Data Type	Double Data Type	Double Data Type

[CoG]

If the column names are different than the form I included in the REGEX_Match function, then that will not work. I'm not sure why you would get that error since the REGEX_Match is running on Field Name which is always string type.

Using the data provided, I had no issues on my end after changing the REGEX expression to ".*\d.*". So the table you include is exactly the format of your data? I even tried changing the field name to just a number (e.g. "2") and it still worked on my end.

[SGK_TS]

Hi  AndrewDMerrill

Thanks for your response, Now it is working fine however small rectification needed, Less than 4 is highlighting in color including blank see attached, i would want only number less than 4 should be highlighted except blank , request you to help me 

Thank you so much for your time and help 

[CoG · Accepted solution]

Change the formula to this then:

IF REGEX_Match([_CurrentFieldName_], ".*\d.*") && !IsNull([_CurrentField_]) THEN ToNumber([_CurrentField_])<=4 ELSE 0 ENDIF

[SGK_TS]

Thank you so much Andrew, it's working as expected