To check if a column is present or not

[mrai02]

Hello Alteryx Community,

I have a dataset in which I need to check if it contains a certain column or not.
if it does, I want to pass it through Workflow 'A'.

if it doesn't, it should pass through Workflow 'B'.

I would really appreciate it if this could be done in a easy and simple to implement way.

Thanks in Advance for the help.

[Felipe_Ribeir0 · Accepted solution]

Hi @mrai02 

With the field info tool you can see which columns the dataset has and build the logic after that. Take a look at the attached workflow.

[mrai02]

Hello @Felipe_Ribeir0,

Thanks for your overview on the issue.

but I have multiple rows in the dataset and due to append fields it is multiplying number the rows with number of columns it is receiving from field info. if possible is there any other way in doing so?

[Felipe_Ribeir0 · Accepted solution]

Hi @mrai02 

Use the sample tool =1 before of the append tool.

[mrai02]

Thanks @Felipe_Ribeir0 for the solution.