Forum Discussion
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
- AnonymousNot 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.
- AnonymousNot 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!