I need someone to code me a Tableau calculated field that will receive a Parameter (P1) as input. P1 will be a string with the following format:
"[string1] [operator1] [string2] [operator2] [string3] [operator3] [string4] [operator4] [string5]"
[string] can be any string
[operator] can be any, and only one, of AND/AND NOT/OR
P1 Example: ABCD OR BCDE AND DE AND NOT CDE
The calculated field should be built based on CONTAIN clause, which means that, for every calculation, the algorithm should allways read: CONTAINS [string] AND/AND NOT/OR CONTAINS [string]....
The calculaiton result should be an integer:
1 if the current record is TRUE for the calculation
0 if the current record is FALSE for the calculation
-1 if P1 doesnt comply to the desired P1 format
6 freelancers are bidding on average $116 for this job
Hi, I have read your project description and understood it. I am very interested to do this project and found it easy. I have 4+ years of experience in the same area. Thanks, Sonali.