Making reference to a field from another input file using a formula

[tsao88]

Is there a way to reference a field from another input file within the same Alteryx canvas using a formula?

For example:

ELSEIF CONTAINS ([FieldX], "hello") THEN...

however [FieldX] is located in another input file within the same canvas

[binuacs]

@tsao88 you can use the Find and Replace tool or Join tool for your use case. you need to read both your input files using the input tool then connected to any of these tools mentioned.

[tsao88]

another questions is related to null, for example

IF ISNULL([FIELD_1]) THEN
"hello"

Does Field_1 have to have the word 'null', or it could be empty, and the output result would be "hello"? 

[TUSHAR050392]

Hey @tsao88, Field_1 needs to have null but if you are not sure about your data so just make your formula robust, you can say - IF ISNULL(FIELD_1) OR ISEMPTY(FIELD_1) THEN 'hello'.