hi everyone! thanks for your help! this is what i am trying to accomplish.
dataset1:
Product ID | name | price |
1001 | table | $ 100.00 |
1002 | sofa | $ 250.00 |
1003 | chair | $ 40.00 |
1004 | loveseat | $ 150.00 |
1005 | bed | $ 300.00 |
1006 | mattress | $ 100.00 |
dataset2:
Product ID | Date Sold |
1001 | 10/31/2021 |
1004 | 11/3/2021 |
1006 | 11/1/2021 |
dataset3:
Product ID | name | shipping |
1001 | table | california |
1002 | sofa | oklahoma |
1003 | chair | texas |
1004 | loveseat | california |
1005 | bed | texas |
1006 | mattress | texas |
dataset4:
Product ID | name | price | Date Sold | shipping |
1001 | table | $100 | 10/31/2021 | california |
1002 | sofa | $250 | oklahoma | |
1003 | chair | $40 | texas | |
1004 | loveseat | $150 | 11/3/2021 | california |
1005 | bed | $300 | texas | |
1006 | mattress | $100 | 11/1/2021 | texas |
sample workflow: