Hi All,
I have created a workflow where if the field (in my case it's Currency), does not follow roughly 200 currencies i.e., USD, EUR, ... etc, then it should highlight Yellow on the Excel Output. I have used the RegEx to check whether or not the field is in a certain expected format (i.e. containing the currency abbreviation or not), and it works! I have also done a similar Formula for the field Country that needs to follow roughly 100 country abbreviations i.e., USA, FRA, AUS etc.
However, I have around 23 Currency fields that follow the exact same formula but have different data. I can do this right now, but I will have around 24 RegEx formulas so it will get quite messy. Is there a faster way to do this?
I have attached two files. The first file (Workflow 1 Original) showcases the above problem. The second file (Workflow 2 Amendments) was worked on by someone else who tried to solve this problem but it's quite confusing. They also made the following points:
- As we have a common Record ID field in both datasets, we can use the purple Join tool to bring both tables into one flow with all of the columns available. [Table 1 as L input, Table 2 as R input]
- From here, we can use the blue Formula tool to update the currency columns in Table 1 to include the values and if they marked True/False. This can be done by writing a formula such as “[currency]” + “_[right_currency]” which will then print “EUR_False” as an example.
- From here, we can use the orange Table tool and apply row rules to identify and highlight anything with ‘False’ in the cell. For a clearer view, it may be best to change ‘True’ and ‘False’ to ‘T’ and ‘F’ respectively to make the cells appear less clunky
Any help will be appreciated! Thanks.
