Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

add a column

Hello all,

I am doing data profiling of multiple tables (around 45 tables) in one table(shown below). I also want to add an error count column to this.How can I do this?

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Could you try to explain whta you are looking for in a better way please?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous I have created a query in which I have data profiling details about multiple tables columns like max, min value, null count standard deviation etc. I want an error count column too in it like null count.how can i achieve that?

      • dax's avatar
        dax
        Community Support
        6 years ago

        Hi chahatkaur, 

        I am not very clear about your requirement, did you mean when the null  count column is 0 or blank, you want to show it as other value? If so, you could  use condition in M code like : if [column] =0 or [blank]=null then condition A else condition B. If this is not what you want, please correct me and inform me more detailed information(sample data and expected output)? Then I will help you more correctly.

        Best Regards,
        Zoe Zhi

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.