Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Does anyone know if there is a simple way to simplify a Table without using a formula? I could create a new column in a Formula tool and put "if Store is null then Store ID".
But I wonder if there is another way to do this ?
That depends on how the data got that way to begin with. Are they from two different files or branches of the flow? You could just use a select to change the column name.
If the data comes in that way, you could split the data using nulls in the first column and a couple selects to remove the null columns and rename and union them back, but that seems a bit more complicated than just using a formula.
