Letters/ Alphabets

[Farriyajawed]

Hello, 

I am trying to get a column where if banana has a value of 2, it gives me the corresponding letter 2 times, BB. Not sure how to achieve this in Alteryx. 

[Prometheus]

@Farriyajawed Try this expression in a Formula tool: 

if [Name]='banana' and [Value]=2

then [Letter]+[Letter]

else null()

endif

 

[Farriyajawed]

I want it to be dynamic because what if the count of bananas is 28?

[PhilipMannering]

Hi @Farriyajawed 

You mean like this?