Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Merge two tables with different values

I have two tables that are generated from a database, which contain the counts of invoices issued and invoices processed. In the first table, are the issued (the days column can change the values...
Ajith_Kumar's avatar
Ajith_Kumar
Frequent Visitor
3 years ago

Hi,

Please follow the following steps.

 

1. Merge the query using Full Outer Join.

2. Next Expand all the columns in table.

3. Create the custom column using the following code.

 

4. Rename the custom column name as Dia.

 

5. Reorder the colum and replace the null values in as 0 to value columns.

 

6. Please the below screenshot as solution.

 

 

Please mark this as solution. I hope you got the solution.