I am trying to link our reseller data set with our payables dataset.  Currently both of these tables have data partitions based on the date we received the data.  For example the invoice from the reseller might be in Febuary but it might get paid in march.  When I do the lookup, it does not find it in the months.   I am trying not to create a second table that would have this but not being a date partitioned.  Any ideas?  Thanks!
#TBMStudio

Not without creating another table, unfortunately.  I'd check out one of the tables, delete the Date Partition, go to the Table step, right-click, and select 'Create New Table from This Step'.  Then you have everything in one table without having to recreate anything from scratch.  Then revert the previously checked out table to put the Date Partition step back.  Maybe someone has done this differently and can pop on and let us know😊
Original Message:
Sent: 05-19-2022 16:24
From: Michael Enslein
Subject: Linking 2 different data sets that have date partitions

I am trying to link our reseller data set with our payables dataset.  Currently both of these tables have data partitions based on the date we received the data.  For example the invoice from the reseller might be in Febuary but it might get paid in march.  When I do the lookup, it does not find it in the months.   I am trying not to create a second table that would have this but not being a date partitioned.  Any ideas?  Thanks!
#TBMStudio

I need to test this...

------------------------------
Regards, Guillermo
------------------------------

Original Message:
Sent: 05-19-2022 16:47
From: Jenny Franklin
Subject: Linking 2 different data sets that have date partitions

Not without creating another table, unfortunately.  I'd check out one of the tables, delete the Date Partition, go to the Table step, right-click, and select 'Create New Table from This Step'.  Then you have everything in one table without having to recreate anything from scratch.  Then revert the previously checked out table to put the Date Partition step back.  Maybe someone has done this differently and can pop on and let us know😊
Original Message:
Sent: 05-19-2022 16:24
From: Michael Enslein
Subject: Linking 2 different data sets that have date partitions

I am trying to link our reseller data set with our payables dataset.  Currently both of these tables have data partitions based on the date we received the data.  For example the invoice from the reseller might be in Febuary but it might get paid in march.  When I do the lookup, it does not find it in the months.   I am trying not to create a second table that would have this but not being a date partitioned.  Any ideas?  Thanks!
#TBMStudio