Count column value totals. | Community
Skip to main content
L
LeeC1989
December 11, 2018
Solved

Count column value totals.

  • December 11, 2018
  • 2 replies
  • 2605 views

Hi everyone,

This is my first post, so be gentle!

I'm also new to campaign, so be even gentler!

I am looking to find the most efficient way of calculating column counts of values. The challenge is making is fairly fluid.

The schema that I have, has (as of today), 69 columns. But this can vary on week to week. I'm looking at getting the column count and then sending an alert to someone if the count is 0...this must also count NULL values.

For example -

NameAgeShoe Size
John
Lee45
Elvis21
Greg
James54
Steve27

So this would give me counts of Name - 6, Age - 4 and Shoe size =  0.

This would then Alert to a user saying shoe size is empty!

I don't need to store the counts anywhere permanently.

Thanks to all!

Lee

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Amit_Kumar

    Hi Lee,

    You need to build a query and in additional data use something like below

    count(Iif((@Name=''), NULL, @id))

    count(Iif((@age=''), NULL, @id))

    count(Iif((@shoeSize=''), NULL, @id))

    This should give you the exact count.

    Regards,

    Amit

    2 replies

    Amit_Kumar
    Amit_KumarAccepted solution
    Level 10
    December 11, 2018

    Hi Lee,

    You need to build a query and in additional data use something like below

    count(Iif((@Name=''), NULL, @id))

    count(Iif((@age=''), NULL, @id))

    count(Iif((@shoeSize=''), NULL, @id))

    This should give you the exact count.

    Regards,

    Amit

      Jonathon_wodnicki
      Community Advisor
      Jonathon_wodnickiCommunity Advisor
      Community Advisor
      January 3, 2019

      Hi,

      This can be generalized by iterating over the schema's cols to build a query def (or raw sql), then similarly iterating over the cols in the result.

      Thanks,

      -Jon

      Terms & ConditionsAccessibility statement

      Loading footer...