2

Does someone knows how to check IS Null expression on SISS ?

IF columns is NULL > RETURN NULL , IF is NOT return value from column

I am developing this on DerivedColumn.

enter image description here

FYI: The column is not always in my Excel layout, that is the reason that I have to check if that column exists or not.

Hadi
  • 36,233
  • 13
  • 65
  • 124
Luiz
  • 141
  • 2
  • 14
  • 1
    Checking whether a column is NULL is not the same as checking whether it exists. Can you please word your question so that it is not ambiguous? – Tab Alleman Jun 26 '18 at 14:00

1 Answers1

1

You can use the following expression:

(ISNULL([InputColumn]) || [InputColumn] == "") ? NULL(DT_STR,50,1252) : [InputColumn]

References

Hadi
  • 36,233
  • 13
  • 65
  • 124