Create new column header if not found.

Question

Hi,

Greetings !

I would like to know whether there is tools / formula to create a new column title/header, if it cannot be found before.
The reason is : final output require the show all column title.

Below is the example ( assume the table from client ) :

Employee NameMonthly SalaryWagetypeAmountAngeline4349.17House Allowance300Bruce7722.43House Allowance300Charlotte10483.33House Allowance300Dallot7558.69WFH Allowance100Eugene10483.33WFH Allowance100Friore14016.9WFH Allowance100Glaze14016.9WFH Allowance100Heather4158.33WFH Allowance100Angeline4349.17Lunch Allowance50Bruce7722.43Lunch Allowance50Charlotte10483.33Dental Reimbursement51Charlotte10483.33Dental Reimbursement71Dallot7558.69Dental Reimbursement43Eugene10483.33Dental Reimbursement56

Currently, i only use 'Cross Tab' and 'Formula' tools to get below result :

Employee NameMonthly SalaryDental_ReimbursementHouse_AllowanceLunch_AllowanceWFH_AllowanceAnnual BonusPhone AllowanceCharlotte10483.33122300  00Friore14016.9   10000Bruce7722.43 30050 00Eugene10483.3356  10000Heather4158.33   10000Dallot7558.6943  10000Glaze14016.9   10000Angeline4349.17 30050 00

The issue : there is possibility that the input file contain amount for 'Phone Allowance' and 'Annual bonus'.
In that case, I do not want the formula tools to create 'Phone Allowance' and 'Annual bonus'.

Thanks in advance !

Create New Column.yxmd

ArnaldoSandoval · Answer

Hi fikrizahari,

There is already a macro to add missing columns, it was developed 10 years ago, and here is its documentation: Alteryx: Ensuring fields are in a data stream ; now when

I tried to implement it in your workflow, I did not need it 😳 but it could be I missunderstood your question, anyhow, this is workflow screenshot:

This is how I introduced the Annual Bonus and Phone Allowance columns:

..

This is the workflow supporting these new columns, no need to impelement the macro

HTH

Arnaldo

Create New Column.yxmd