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…
Please check this article and the feature “_THISROW-n”
help.appsheet.com - Template Start Expressions Template Start Expressions help.appsheet.com
@Aleksi_Alkio That’s what I was looking for. Thanks a lot.
You’re welcome
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |