Hello @armingrudd and all, I need to re-open the topic here because the previous topic was closed by system. https://forum.knime.com/t/merge-cell-transpose-and-add-request-date/13167 I found two problems when I start running the second loop of the data which i don’t know how to correct in the workflow: Excel files referring to previous link: Say on 1/1/2019, i have raw data file of tab sheet “Original File Received in wk1” with week number in row 2 from wk51 to wk5. on 7/1/2019, i have raw data file of tab sheet “Original File Received in wk2” with week number in row 2 from wk52 to wk6. I load the two files/tab sheets in the designed workflow and worked perfectly well. However, Say on 14/1/2019, i receive new raw data file with the same format but only indicate week in row 2 from wk1 to wk7. When I load the 7/1/2019 file and 14/1/2019 file in the workflow (because i need to get the most update data therefore i need to load 14/1/2019) file. 7/1/2019 and 14/1/2019 respectively for the first two nodes. then 7/1/2019 and 14/1/2019 again for the 3rd and 4th nodes. Problem happen: Request Date and week don’t match. Week 52 = Request Date 2018-12-17 Week1 = Request Date 2019-12-24 etc Basically, this is a rolling practice, each week i will receive a new raw data file with updated 7 weeks, for weeks that is not available in the new raw data file any more, i need to keep the data in the output file, for the weeks that are mentioned in the new raw data file, i will take the most update data from the new raw data file. on 7/1/2019, i have raw data file of tab sheet “Original File Received in wk2” with week number in row 2 from wk52 to wk6. on 14/1/2019, i have raw data file with the same format with week number in row 2 from wk1 to wk7. Problem happen: If there is some new material number that cannot be found in file 7/1/2019 but is on 14/1/2019, then the material will not appear in output file, but in fact we need those new data in output file. Thanks for help. Rain

Merge cell, transpose and add request date (con't)

armingrudd January 31, 2019, 2:12pm 4

I updated the solution in the main topic.
Please check the workflow and let me know if it’s working fine:

Best,
Armin

1 Like