Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi, @TimLiao , thank you for posting! Can you provide any further details on the thread to assist users in helping you find a solution (insert examples like Dataikuversion etc.) Also, can you let us know if you’ve tried any fixes already? This should lead to a quicker response from the community.
hi @TimLiao ,
attached screenshot shows a simple setup for counting occurrences of substring "ee", and what happens then in the output-column. In case of a Regular expression you can enter that (for example ^.ee.* to search for anything with 2 e's after the first character).
Is this what you are looking for ?
Thanks, i got the meaning of pattern now, but my request is very simple, just want to count the appearance of the value in column. sample attached.
Can you help to advise how to get it as no count formula available here.
thank you veyr much.
In your example you seem to:
If I understand that correctly:
You might take a look at the Window Visual Recipe.
You would want to window on Column 1
Second, you would include a count of the number of records in the windowed partition.
This would then give you the two columns you are looking for.
You can convert this to SQL if you are working with a SQL database backend. This might be a bit more performant.
There are training materials for the visual recipe that you can learn more about.
Here is another post from the community that might help as well.
Hope this helps. Let us know how you get on with this.