Forum Discussion

Muki's avatar
Muki
Icon for Helper I rankHelper I
8 years ago
Solved

Filter table based on two columns and add non calculated columns to it

Hi   I have a source Table A which contains values from appended/ merged tables. I would like to structure the data inside this source table so I get unique records which I need for another merge....
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Have a look at the LOOKUPVALUE function and potentially RELATED or RELATEDTABLE.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Have a look at the LOOKUPVALUE function and potentially RELATED or RELATEDTABLE.

Muki's avatar
Muki
Icon for Helper I rankHelper I
8 years ago

thanks Greg_Deckler the lookupvalue function does indeed what I'm looking for.

But I have still one error message for the search_column in which I have empty dates :

A table of multiple values was supplied where a single value was expected.

 

How can I ignore the empty dates in the column?

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Use VAR to create a temp table with your formula and then pass it through a FILTER(tmpTable,NOT(ISBLANK([Column]))), something along those lines.