topic Re: Expression for kpi while dealing with 2 different tables having same field names in App Development

Expression for kpi while dealing with 2 different tables having same field names

Vikranth — Tue, 25 Jan 2022 17:52:59 GMT

How to deal with 2 tables having same field names but different content in it.

Example:

1st table has field name as status - it contain data as migrated, rejected

2nd table has same field name status- it contain data as queued.

How we can write the expression for data which contains only queued in kpi chart?

Re: Expression for kpi while dealing with 2 different tables having same field names

rwunderlich — Tue, 25 Jan 2022 19:16:14 GMT

=Count({<Status={'queued}>} Status)

-Rob

Re: Expression for kpi while dealing with 2 different tables having same field names

Qrishna — Wed, 26 Jan 2022 02:01:10 GMT

Hi - Rename the other Field to 'status_Whatever'.Make sure you dont have two fields with same names in two table except the key field. else you have synthetic keys and then use expression suggested by Rob in your KPI, if that is the solution you looking for.

Eg:

Tab1:

load Status

from xyz.qvd

Tab2:

load Status as Status_Whatevr

from abc.qvd