Tiger1
September 23, 2020, 6:31pm
1
I am having trouble with a reference expression.
I have two tables:
Assets (Table A)
Geoforce (Table B)
I created a Virtual column in Table A that ref - Table B:
I use this expression to match up the item.
I then use this virtual column to show the column i want:
I am not getting any values?
Steve
September 23, 2020, 6:39pm
2
The App formula expression for Ref Attached Sling cannot itself itself.
Tiger1
September 23, 2020, 6:42pm
3
This?
IFS([_Computed Key] = [Ref Attached Sling].[Newcomputedkey], [Ref Attached Sling].[UNTRACKED ASSETS] )
How do i compare the two tables? I have items in both tables with matching ids.
Steve
September 23, 2020, 6:44pm
4
What are you trying to accomplish?
Tiger1
September 23, 2020, 6:45pm
5
I need to first match the items ( matching the item from both tables) then show the items column (from Table B) [untracked assets] in this table (Table A).
1 Like
Tiger1
September 23, 2020, 7:11pm
6
I got it Steve - thanks for the help…
1 Like
Nice. What was the solution?
Tiger1
March 9, 2021, 8:29pm
10
Sorry. For this late response.
I used this expression and it worked for me:
Select(Geoforce[untracked assets], [Newcomputedkey] = [_THISROW].[_Computed Key],true)
4 Likes
Thank you so much. I really appreciate it!
1 Like