Hi @iskhj000 ,
Do you want to get the table which has the Address’s TCG# is match your second table?
I think you can change your formula expression as next:
Initial Collection: ClearCollect(CollIncompletesv6, Deactivation Incompletes)
Add Address Collection:ClearCollect(collUpdated6,AddColumns(CollIncompletesv6,”AddressLot”,LookUP(‘Master List’, TCG#= CollIncompletesv6.TCG#,Address)))
I test as this:
Button.Onselect: ClearCollect(test2,'[dbo].[Table_20190222DI]');ClearCollect(test3,AddColumns(test2,"Addresslot",LookUp('[dbo].[Table_20190222MasterTable]','TCG#' in test2.'TCG#',Address))) (on your side you can change to your tale’s and column’s name)
Hope this can be helpful.
Thank you Yumia
I think this is close but I am getting the same results as you... but... the addresses end up being the same for all of the records in the updated collection
I was needing the final collection to look like
123 101 no where street
789 103 hereweare dr
Try the following (going back to your original collect statement rather than creating another one).
ClearCollect(collUpdated6, AddColumns(CollIncompletesv6, "AddressLot", LookUp('Master List', 'TCG#'=CollIncompletesv6[@'TCG#']).Address))
This should give you the original collection you wanted - the difference here is the use of a disambiguation operator that will observe your Record Scope properly.
See if that helps.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021