topic Re: Get distinct rows when using inputlookup and lookup in Dashboards & Visualizations

Get distinct rows when using inputlookup and lookup

Rgk_Trail — Sat, 05 Sep 2020 15:58:34 GMT

Hi,

I am using combination of inputlookup and lookup to generate a report. I am using one field to join two lookup tables but both my tables have duplicate values. In the output I want to get unique rows containing fields from both lookup tables but I seem to get duplicate values in 2nd lookup table that I am joining.

I am using dedup to remove duplicates from first table but It doesnt seem to work for second lookup.

Can you suggest better way to do this ?

Re: Get distinct rows when using inputlookup and lookup

gcusello — Sat, 05 Sep 2020 16:13:16 GMT

Hi @Rgk_Trail,

which aggregation command are you using?

I think that using values you shoun't have value duplication problems:

| inputlookup Issue_A | rename Number AS Code | lookup Issue_B Code OUTPUT Field4 Field5 Field6 | stats values(Field1) AS Field1 values(Field2) AS Field2 values(Field3) AS Field3 values(Field4) AS Field4 values(Field5) AS Field5 values(Field6) AS Field6 BY Code

Ciao.

Giuseppe

Re: Get distinct rows when using inputlookup and lookup

Rgk_Trail — Sat, 05 Sep 2020 20:23:55 GMT

Hi Giuseppe,

Thanks for the quick response. I tried using your code but now it gives me error :

RROR LookupDataProvider - Could not find all of the specified lookup fields in the lookup table.

Re: Get distinct rows when using inputlookup and lookup

gcusello — Sun, 06 Sep 2020 09:51:15 GMT

Hi @Rgk_Trail,

check all the field names (both the key field and the OUTPUT fields) remembering that field names are case sensitive.

Ciao.

Giuseppe