Value based on values in 3 different columns in Straight tbl
Hi There,
I have below calculated field in the script, which look for a specific string ie CD & Disc in Name and Desc fields to flag it.
if(SubStringCount(Name&Desc, 'CD') >0 or SubStringCount(Name&Desc,'Disc') >0, 1, 0) as Flag.
I want to move this logic from script to directly in a straight table.
This means I want substringcount() to look for values in the adjacent columns(Name and Desc) in the straight table and create a flag in the Flag column.
substringcount is a chart function as well so you can straight away use that in your column. if Name and Desc are fields and is included in your straight table you can use that as well. however, if for some reason you need to check the table columns based on the position in your table you can use the column function
