Forum Discussion

Switto's avatar
Switto
Icon for Helper IV rankHelper IV
6 years ago
Solved

if condition between two tables

Hello Everyone,   I am working on Time and Motion data which requires excluding the line items which are not aligned to Project TAT.   So I have a table which has data for day to day line items w...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Switto - You will want to use RELATED or RELATEDTABLE or possibly LOOKUPVALUE and could also use MAXX(FILTER(...)...)

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

Switto - You will want to use RELATED or RELATEDTABLE or possibly LOOKUPVALUE and could also use MAXX(FILTER(...)...)

  • Switto's avatar
    Switto
    Icon for Helper IV rankHelper IV
    6 years ago

    Thanks for the tips 🙂 Let me read up and try to put into solution.

    Appreciate your quick reply.

  • Switto's avatar
    Switto
    Icon for Helper IV rankHelper IV
    6 years ago

    Greg_Deckler : Thanks for the tip. I have used the "lookupvalue" to get the data from my AHT file to Rawfile.

     

    It worked for taking the minimum time however, while using it for Maximum time, got the error "A circular dependency was detected: RawFile[mMax_Time], RawFile[mMini_Time], RawFile[mMax_Time]."

     

    I have used formula for mini. as 

    LOOKUPVALUE(AHT[mMin_AHT_Sec],AHT[Process Name],RawFile[Action name],AHT[Size],RawFile[mTree_size])
    and, Max is 
    LOOKUPVALUE(AHT[mMax_AHT_Sec],AHT[Process Name],RawFile[Action name],AHT[Size],RawFile[mTree_size])
    I am not sure why I am getting this.
    Any idea will help.