If i have a nested select statement of 3 sele...

workflow
(Deep Foundations) #1

If i have a nested select statement of 3 selects in a report (each from 3 distinct tables, table1, table2, and table3), and they all have a field called “Unique ID” that may store different values in each but has the same name. How do i differentiate the field for each table?

Example:

<<Start: Select(Table1[Unique ID], [ABC]=“ABC”)>>

<<Start: Select(Table2[Unique ID], AND([ABD]=“ABD”, [Unique ID]=[Unique ID])>> #The second Unique ID is for the table1

<<Start: Select(Table3[Unique ID], AND([ABE]=“ABE”, [Unique ID]=[Unique ID])>> #The second Unique ID is for the table2

<>

<> <>

Something along those lines…

(Aleksi Alkio) #2

Please check this article and the feature “_THISROW-n”

help.appsheet.com - Template Start Expressions Template Start Expressions help.appsheet.com

(Deep Foundations) #3

@Aleksi_Alkio That’s what I was looking for. Thanks a lot.

(Aleksi Alkio) #4

You’re welcome