data comparison

AppSheet AppSheet Q&A
1

Hi,

I have 2 tables for example, Main and secondary, main contains an id(unique id) and column called “serial” along with some other data columns,

secondary table contains a “Serial number” column and some other data columns ( this number is unique so could it be the key or should i just use the row number ?

I want to compare the two serial columns and see if they match. Should i make one of the columns a ref column in the secondary table back to the main table.?. the resulting view to show differences in the two.

I had been trying something like the following but getting confused what part looks at what,

Other posters expression i took inspiration from

[Email Address] <> ANY(SELECT(Main Table[Email Address], 
                              [Employee ID] = [_THISROW].[Employee ID]))

My take on the expression

[Serial]<> ANY)Select(Main[Serial], …

Also confused if the slice should be on the main table or secondary table ?

2

Don’t use the row number as key. Generally speaking, never use the row number as key.

Is the goal with the slice to show only rows of the secondary table that have a serial number that matches the serial numbers of rows in the main table? If yes, create a slice on the secondary table with a row filter expression similar to this:

IN([Serial], Main[Serial])
3

Yes that was what i was trying to do. Used an expression like yours.

If i wanted to expand on that and create a true based on the columns not having the same data eg in the secondary table the column has a row that has “12345” and the main table has a row with 12345@789 but both have the 12345 part in them, what would be the best way to do that. I tried using contains at the start instead of IN but it didn’t give the desired result.

12345@7890 + 12345 = True or it could be 789@12345 + 12345 = true , So true if both columns have a partial match

1 Like
4

This is more complex so IN() won’t be sufficient. Instead, try this:

ISNOTBLANK(
  FILTER(
    "Main",
    CONTAINS([Serial], [_THISROW].[Serial])
  )
)