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
Hi @dkma
Can you provide sample input data and expected output. So that we can look into the usecase 🙂
Hi @atcodedog05 ,
Table.HasColumns - PowerQuery M | Microsoft Docs, This is what I'm looking for in Alteryx.
Can you please look into this
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: