Forum Discussion
Creating a duplicate column and filtering
Hi there, I am trying to create a duplicate column. My original column is 'Status' and I am duplicating this and renaming it as 'Rejected'. When I am filtering the 'Rejected' column, it is doing...
for that, first you have to
1. make duplicate table then
2. filter the column from the duplicate table
3. then go to the original table and select the merge query option
4. select the duplicate table as second table and select the common column from both the table
5. select left outer join then one extra column will be create.
6. from that table you can expand the joined column