Adding Fields to Data Prep Append Table

Janet_21505
Janet_21505 Altair Community Member
edited July 2021 in Community Q&A

I have added another field into these 3 tables, Name1, Name2, Name3 AFTER the append was created.  The append is not wanting to stack the data, but create separate columns.  I have validated the formats and name are the same.  The append is part of the first steps in the workspace, so hoping there is a fix for this and I just missed the "how to".  Her are some screen shots. 

 

image

imageimage

Tagged:

Answers

  • Janet_21505
    Janet_21505 Altair Community Member
    edited July 2021

    Should have mentioned Zip 5 is the new field I am trying to add to the append. It is in all 3 tables

  • Janet_21505
    Janet_21505 Altair Community Member
    edited July 2021

    I think I just figured it out.  Drag and drop the field from Name2 and Name3 on top of the Zip5 field from Name1 already in the list.  

Categories