Replace Nulls with Text in Alteryx

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ก.ค. 2024
  • In this video I show how you can replace null with blanks or with specific text. I also show how you can replace specific text with nulls.

ความคิดเห็น • 2

  • @ashishsalunkhee
    @ashishsalunkhee 2 ปีที่แล้ว

    While using multi field tool, how can we add a new column and add comment “no value” if the values in any columns is null ?

    • @tutorialsin5minutesorless262
      @tutorialsin5minutesorless262  ปีที่แล้ว

      I suppose you would not need to use a multi field tool to do this. After all, if you only want to create one new field you can use the normal formula tool.
      Lets assume you have three fields, A, B and C, you can write a formula like this:
      IF [A] = Null() OR [B] = Null() OR [C] = Null() THEN "no value' ELSE 'a value exists' ENDIF
      This formula will produce "no value" whenever one of those fields is null. If you want it to show "no value" when ALL fields are null you would need to do this:
      IF [A] = Null() AND [B] = Null() AND [C] = Null() THEN "no value' ELSE 'a value exists' ENDIF