Forum Discussion
JemmaD
Helper V
Helper VAppend distinct selected columns in PQ
Hi there, I have four tables, all of which hold two common columns called [Mailbox] and [Business Type] I want to append the four tables with distinct values of these two columns I tried bringi...
I suppose you need it for a dimension table. have you tried to duplicate the 4 tables. Disable the load on the duplicates. Leave just the 2 common columns. Then select Both columns and remove duplicates. Do it for all 4 duplicates same steps. Once done append them toghether. And on the appended table do again a duplicate removal on both columns.
