Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Fetch values for field values in one table which is not available in the other table

Hi,

 

So my data looks like this:

Table1 (T1):-

custid, month

ABC, sep-20

XYZ, apr-20

 

Table2 (T2):-

custid, month, value

ABC, sep-20, 80

ABC, dec-20, 70

XYZ, apr-20, 50

XYZ, may-20, 40

 

I'd like to retrieve both the values from T2 when

1. customer ABC is filtered (based on T1.custid)

2. Timeperiod from Jan'20 to Dec'20 (based on T1.date)

 

Specific use case is to put the retrieved values in a chart.

 

Final table (T3):

Filter selection - custid= ABC, timeperiod = Jan'20-Dec'20

 

custid, month, value

ABC, sep-20, 80

ABC, dec-20, 70

 

I'd like your help in solving this problem. Thanks in advance!

 

 

 

 

 

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    Sorry not very clear.  

    Can you fill up your sample data and give your expected results in detail?

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hey Anonymous, thank you for your reply. I have augemented the details in the original post. Please let me know in case more information is needed!