topic Re: Create column with related fields from two tables (In Table view) in Developer

Create column with related fields from two tables (In Table view)

Anonymous — Fri, 11 Oct 2024 17:15:32 GMT

Hi, Table 1 contains Jobname column with X,Y,Z. I want to create another column Time in this table with related fields from other two tables matching this X,Y,Z. Table 2 contains time of X, Table 3 contains time of Y, Z.

TABLE 1		Table 2		Table 3		Result Table should be like this
jobname	Time	jobname	Time	jobname		jobname	Time
X		X	9:00 AM	Y	10:00 PM	X	9:00 AM
Y				Z	11:00 AM	Y	10:00 PM
Z						Z	11:00 AM

Re: Create column with related fields from two tables (In Table view)

lbendlin — Fri, 11 Oct 2024 21:46:06 GMT

Result = UNION('Table 2','Table 3')

Re: Create column with related fields from two tables (In Table view)

Anonymous — Mon, 14 Oct 2024 02:18:02 GMT

Thanks for the reply from lbendlin , please allow me to provide another insight:
Hi @Anonymous ,

Here are the steps you can follow：

1. Create calculated column.

Time = var _table2= MINX( FILTER(ALL('Table2'),'Table2'[jobname]=EARLIER('Table1'[jobname])),[Time]) return IF( _table2=BLANK(), MINX( FILTER(ALL('Table3'),'Table3'[jobname]=EARLIER('Table1'[jobname])),[Time]) ,_table2 )

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly