'How many 1's are there in selected column/row in Informatica?

I am very new to Informatica. Now I would like to Count how many 1's are there in selected row in Informatica, which we could do easily in excel using COUNTIF formula.

For example, column1 - a,b,c,d ; column2 - 1,2,1,4 ; column3 - 1,1,3,5

How to write expression in Informatica to calculate how many 1's are there in each row (a,b,c,d)?

countexpressioninformatica


Solution 1:[1]

occurrence of any string can be calculated like this -

length(column1 ) - length(replacechr(column1,'1',''))

Take the total length of string and then minus length of everything else in the string.
Use an exp transformation and calculate how many 1 exist in column column1 ,column2,column3...

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Koushik Roy

Related Questions

How to determine an object's value in Python

javascript - match string against the array of regular expressions

After Effects Expressions - controling comps from main comp using an "Expressions Layer"

How can I use a built Expression in an Include .Where() to apply an Include Filter when it expects Expression but only allows Func?

print when expression to display Static text if there is atleast a not null field in a detail band

How can I filter in Birt (Parameter) on a computed column?

LINQ Expression GroupBy Select First

IQueryable extension to group dynamicly by minutes ...and other

Difficulty in create regex [duplicate]

Regex to match code with fixed country code and variable wildcard usage

How to sort entity model by column name of display model in C# .NET Core using LINQ?

mapbox : how to combine two expressions to style a layer?

Evaluate String expression in Swift just like javascript eval

IP Address regex with netmasks

Expression to check if a given string exist in a output of a script task in ADF