It is possible to use Suggested_Values to pul...

(Simon Robinson) #1

It is possible to use Suggested_Values to pul in two columns of unique values from 2 separate tables?

I need to combine

Select(Defect[Location],[Job]=[_ThisRow].[Job])

and

Select(Checks[Location],[Job]=[_ThisRow].[Job])

TIA

#2

Hi @Simon_Robinson Did you try it?

(Simon Robinson) #3

No, I can’t find a way to combe 2 lists

#4

I don’t know if it will work, I don’t have anything to test it with but you could try.

Select(Defect[Location],[Job]=[_ThisRow].[Job]) +Select(Checks[Location],[Job]=[_ThisRow].[Job])

(Praveen Seshadri (AppSheet)) #5

Yes, that’s a valid way to combine two lists of similar type