Creating SNOW Report with multiple tables when tables have no similar columns. The report must be in list view

[Raghav Manchan1]

Hi Team,

I'm trying to generate a report from two tables by using Database view to combine two tables. Since I don't have any similar column between two tables. Is it possible that I can generate a report from it. one column is common but there are some missing entries in that column which will not compare itself to other tables.

[Ankur Bawiskar]

Hi,

Since you mentioned there is 1 column which is having common data

You can use it to create database view.

now for the data which is missing in the column; you need to discuss with your customer why it's empty and if empty then what should be populated in it

Then only your database view would show those records.

regards
Ankur

[Ankur Bawiskar]

@Raghav Manchanda 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards
Ankur

[Hitoshi Ozawa]

Hi Raghav,

What will the report contain if the two tables don't have records that are not related? If the records in the 2 tables are not related, why is there a need to combine them into 1 report instead of having 2 reports?

Can it be that a report is to be generated by combining just records with non-null common column? That is, to set a filter condition of the column that is common to both tables to be "columnName != null"?