How to use two data sets that don't have any fields in common?

Question & Answer
, ,
1

Hi All,
I have two different datasets: payments and customer support. I’d like to graphic number of customer support tickets by number of payments.
Is there any possibility to use a calculated field from two different datasets or I have to join them for example using date field?

Thanks

2

Hi,

Ideally, for good structure design you must a at least one key like production_Id or order_id or any column which related both the dataset.

you can use the date field with the LEFT joint left table should be greater in number of record from the right table/tables
but cannot do with timestamp.

regards,
Naveed Ali

1 Like