How to populate Join output only if a column is not null in some other file

[ShantanuDagar]

Hi all,

Attaching a pic of workflow for reference.

In the middle join (inside red rectangle), the L output is being populated based on some requirements.

I want that output to be populated only if a "Column M" is not null in some other input file. Because this particular process is used only when there is no "Column M" in that input file. This input file is not being directly used in this particular join. It was used only in 1st join.

If the column M is not null in that input file (column M is present in that input file), then only null vales must be out of corresponding Join output anchor. No data.

So that the final excel output sheet is empty for the corresponding tab - "Modify".

From the perspective of filter tool after that join, Will be good enough if there is only T values outputted if "Column  M" is null in that input file, And only F values if "Column M" is not null in that input file.

[MatthewO]

@ShantanuDagar I have attached an example that I believe demonstrates how you can accomplish this. I may not be completely following your requirements but the attached workflow will count if "Column M" exists in the data set, append the Count to the entire data set, then filter it into separate data streams. I hope this is helpful for you!