Find if there are certain columns in a Dataset

[dkma]

Hello, I have a dataset has columns from 1 - 30. If there are no 31 columns we should a 31st column to the dataset. 

Any leads on this would be much appreciated

It is replica of "Table.hasColumns" in Power query

[atcodedog05]

Hi @dkma 

Can you provide sample input data and expected output. So that we can look into the usecase 🙂

[dkma]

Hi @atcodedog05 ,

Table.HasColumns - PowerQuery M | Microsoft Docs, This is what I'm looking for in Alteryx. 

Can you please look into this

[KaneG]

You can use a Field Info tool on the data to get a list of the columns if you just want to check, but if you want to enforce that the column exists, you can just skip that and union on a dataset with the complete column list. 

As such: