append two columns from the same table

Question

Hi,&nbsp;On my table, TBL1, I have two fields, ISIP_ID and ISIN_ID. I need to combine them into a single column CUSIP_ID while eliminating the duplicates and blanks. If I add a new column, how do I do the append?&nbsp;TIA

serpiva64 · Answer

Hi,
I tried to do this way and it functions (in my case)
- Duplicate your table
- in the duplicated table rename&nbsp;ISIP_ID as&nbsp;ISIN_ID and viceversa
- then append as a new query

- remove duplicates

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
&nbsp;
&nbsp;

syk · Answer

Select the 2 columns you'd like to combine &gt; right click one of them &gt; Merge columns

&nbsp;

syk · Answer

A quick note.. If you want to keep your original 2 columns, navigate to the Add Column tab &gt; Select columns &gt; Merge Columns in the ribbon

&nbsp;

serpiva64 · Answer

Hi,
can you post some sample data?

rollingzep · Answer

I don't want to merge, I need to append. I do not need something like lastname, firstname. I need it as one below the other. I need col B values below col A.&nbsp;&nbsp;

Forum Discussion

append two columns from the same table

5 Replies

Related content

Append table kpi's

Dataflow - Append

Table append issue

Append columns of the same table

Append columns from same table