Forum Discussion
MKPartner
Helper II
Helper IIUniqe table caming from three tables
Hi Team,
I have three tables which aren't in relation but has the same column "mfg_ord_no". I'd like to make from each one combined separate table with only one columnt with only uniqe values. Is there possibility to do it ?
MKPartner , You can create common table
distinct(union(distinct(Table1[mfg_ord_no]),distinct(Table2[mfg_ord_no]),distinct(Table3[mfg_ord_no])))
and join with three tables to analyze together
1 Reply
- amitchandak
Super User
MKPartner , You can create common table
distinct(union(distinct(Table1[mfg_ord_no]),distinct(Table2[mfg_ord_no]),distinct(Table3[mfg_ord_no])))
and join with three tables to analyze together