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?
Solved! Go to Solution.
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).
The App formula expression for Ref Attached Sling cannot itself itself.
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.
What are you trying to accomplish?
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).
I got it Steve - thanks for the helpโฆ
What did you get?
I figured it outโฆ
Nice. What was the solution?
Sorry. For this late response.
I used this expression and it worked for me:
Select(Geoforce[untracked assets], [Newcomputedkey] = [_THISROW].[_Computed Key],true)
Thank you so much. I really appreciate it!
User | Count |
---|---|
16 | |
10 | |
10 | |
8 | |
3 |