Matching column with multiple columns and show matched/not matched

[kaushi2020]

Dear All,

I have Table1 with InvoiceId, which I have to match with Id, TransId and PaymentId respectively in Table2. If InvoiceId from Table1 match with any one of these 3 columns, then show status as Matched. Else show not matched in a table. Please suggest. 

[rubenmarin · Accepted solution]

Hi, after you have table2 loaded, you can load InvoiceId and use Exists() to check is the value is loaded.

LOAD
  InvoiceId,
  If(Exists('Id',InvoiceId) or Exists('TransId',InvoiceId) or Exists('PaymentId',InvoiceId),' Matched' as Status
From/Resident ...

[kaushi2020]

Thanks for the reply, the resident load should be from table1 or table 2 ? 

[rubenmarin]

Hi, it should be the table where InvoiceId is, so from table1.

[kaushi2020]

Thanks a lot for the solution. Much appreciated.