You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
2nd basic question of the day
I am returning a list of values in a table that are split into 4 categories looking at the raw data. the format is as follows
create-aaa
read-bbb
update-ccc
delete-ddd
create-eee
read-fff
I want to be able to show the info as a simple chart for the totals of the 4 categories create, read, update and delete, so in the example above i would see
create = 2, read=2, update=1 and delete=1
is there a simple way of doing this without going into complex CQL in the table transformer macro?
@Hi @Craig.Harley, will this code example help solving the problem?
SELECT ColA::string->split("-")->0 as res
FROM T*
TimK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you @Tim Kopperud for your help, couldn't have given a better example ourselves!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.