# Solutions to "Just KNIME It!" Challenge 33 **URL:** \ **Category:** Just KNIME It!\ **Tags:** justknimeit\ **Created:** [September 7, 2022, 1:35pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-33/46826 "2022-09-07T13:35:05Z")\ **Posts on this page:** 11\ **Page:** 2
**Author:** ![FlowCreator](https://forum-cdn.knime.com/user_avatar/forum.knime.com/flowcreator/32/44972_2.png) [@FlowCreator](https://forum.knime.com/u/FlowCreator)\ **Post date:** [October 5, 2022, 10:28am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-33/46826/21 "2022-10-05T10:28:52Z")
Hi guys, I have a question to the offical solution cause I get an error message in the “Loop End” node. All is running well till the “Loop End” node. But after 1st iteration I get the following error message: Execute failed: Input table’s structure differs from reference (first iteration) table: different column counts 4 vs. 3 Can someone explain me how I can fix this problem? I have no idea what the problem is. After the String manipulation node the table has 4 columns. Thanks in advance BR FlowCreator 😉 ![Loop End node error - challenge 33](https://forum-cdn.knime.com/uploads/default/original/3X/6/9/69d5102d77f73d3331e2419ebc77c04ed5e17428.png) ---
**Author:** ![alinebessa](https://forum-cdn.knime.com/user_avatar/forum.knime.com/alinebessa/32/33306_2.png) [@alinebessa](https://forum.knime.com/u/alinebessa)\ **Post date:** [October 5, 2022, 1:52pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-33/46826/22 "2022-10-05T13:52:39Z")
Hi, did you try checking the “Allow changing table specifications” option in the Loop End node configuration? This may help. ---
**Author:** ![FlowCreator](https://forum-cdn.knime.com/user_avatar/forum.knime.com/flowcreator/32/44972_2.png) [@FlowCreator](https://forum.knime.com/u/FlowCreator)\ **Post date:** [October 5, 2022, 2:31pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-33/46826/23 "2022-10-05T14:31:56Z")
Hi great this works! When have I used this option? But I get a new error message in the “Table Row to Variable” node: Execute failed: Missing values are not allowed for data types without a default value. – column “Path” (index 0) ![New error - challenge 33](https://forum-cdn.knime.com/uploads/default/original/3X/3/7/375380cc6569a7492820e401d885453f3cab8738.png) Believe me I haven’t change the workflow, only the directory of the data to my local drive on the laptop Thanks for your help BR FlowCreator ---
**Author:** ![alinebessa](https://forum-cdn.knime.com/user_avatar/forum.knime.com/alinebessa/32/33306_2.png) [@alinebessa](https://forum.knime.com/u/alinebessa)\ **Post date:** [October 5, 2022, 3:56pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-33/46826/24 "2022-10-05T15:56:48Z")
Hey, This error may be caused by a variety of things… Is your solution on [KNIME Hub](https://hub.knime.com/)? If so, could you share it here? If not, it’d be great if you could upload it to KNIME Hub and share with us here. I’d be happy to then take a look at it and try to find the issue. 🙂 ---
**Author:** ![FlowCreator](https://forum-cdn.knime.com/user_avatar/forum.knime.com/flowcreator/32/44972_2.png) [@FlowCreator](https://forum.knime.com/u/FlowCreator)\ **Post date:** [October 6, 2022, 12:29pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-33/46826/25 "2022-10-06T12:29:48Z")
Hi Aline, thanks for your answer no my solution is not on KNIME HUB. Buts it is only the official solution and I have changed only the file links to my local drive. But I will uploaded it here. Is this normal that the reset workflow has 350MB? I have reset the workflow before exporting Bad try - It is no possible to upload such a big file. How can I make it smaller? A ompressed zip file is also not working LG FloweCreator ---
**Author:** ![victor\_palacios](https://forum-cdn.knime.com/user_avatar/forum.knime.com/victor_palacios/32/37922_2.png) [@victor\_palacios](https://forum.knime.com/u/victor_palacios)\ **Post date:** [October 6, 2022, 2:24pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-33/46826/26 "2022-10-06T14:24:53Z")
That is very odd. I tried running it as well and didn’t face this issue. I wonder if the downloaded data has changed since our solution. And please don’t upload that data as it’s too large and region restricted. ![Screen Shot 2022-10-06 at 7.23.29 AM](https://forum-cdn.knime.com/uploads/default/original/3X/d/b/db748a78698d6b050d8175df7901271a6608a170.png) If the data has changed, the solution may not work, sorry about that. ---
**Author:** ![alinebessa](https://forum-cdn.knime.com/user_avatar/forum.knime.com/alinebessa/32/33306_2.png) [@alinebessa](https://forum.knime.com/u/alinebessa)\ **Post date:** [October 6, 2022, 10:52pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-33/46826/27 "2022-10-06T22:52:03Z")
Thanks for the reply, @victor_palacios! @FlowCreator if you still have any questions on this, please let us know. We’re here to help. 🙂 Thanks! ---
**Author:** ![FlowCreator](https://forum-cdn.knime.com/user_avatar/forum.knime.com/flowcreator/32/44972_2.png) [@FlowCreator](https://forum.knime.com/u/FlowCreator)\ **Post date:** [October 7, 2022, 6:42am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-33/46826/28 "2022-10-07T06:42:59Z")
Thanks again for your answer. How do you have run the Workflow? Do you have run the Workflow on Local Drive or on the Internet? My understanding is, that I have to run it on local drive, cause I have to download the data. I make again the test, download the workflow, download the data and run it on local computer. But it is no working. After downloading and saving the workflow I get the error message in the 1st List Files/ ![List Folder changed folder](https://forum-cdn.knime.com/uploads/default/original/3X/d/9/d937522119a2bea1ccadcb62e5a224ead7db8856.png) ![List Folder error message](https://forum-cdn.knime.com/uploads/default/original/3X/4/f/4f107c61d4377912812e5f90aad7ca94e479c535.png) Folder node: The specific folder chargemaster -cdm-2021 does not exist So that I have to change it to the local drive on my Laptop, see the 2 screenshots: Then I try to run the complete workflow and it stops in the Metanode at the Excel node: error message: ERROR Read Excel Sheet Names 3:25:0:33 Execute failed: D:\KNIME\_workspace\Challenge\Challenge 33 - Medical Procedure Prices - Solution\data\Kaiser Foundation Hospital - Antioch\106074097\_CDM\_2021.xlsx is not a folder. Please specify a folder. When I change the setting in the List file node to Mode: Folders (before Files in folders) then I get the error message: ERROR Read Excel Sheet Names 4:25:0:33 Execute failed: D:\KNIME\_workspace\Challenge\Challenge 33 - Medical Procedure Prices - Solution\data\Kaiser Foundation Hospital - Antioch is a folder. Please specify a file. So please explain me how the setup the List Files node Thanks for your help LG FlowCreator ---
**Author:** ![victor\_palacios](https://forum-cdn.knime.com/user_avatar/forum.knime.com/victor_palacios/32/37922_2.png) [@victor\_palacios](https://forum.knime.com/u/victor_palacios)\ **Post date:** [October 7, 2022, 5:10pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-33/46826/29 "2022-10-07T17:10:27Z")
So based on this image, the files did in fact change which may have caused your first issue you stated earlier - you have twice the number of files I had. For this new error, the relative path with current workflow data area will only work with what you specified if that exists in a folder called data within your workflow. Here is how to read in files in KNIME: [Reading Files in KNIME - YouTube](https://www.youtube.com/watch?v=IiZsOnhZgzk) ---
**Author:** ![FlowCreator](https://forum-cdn.knime.com/user_avatar/forum.knime.com/flowcreator/32/44972_2.png) [@FlowCreator](https://forum.knime.com/u/FlowCreator)\ **Post date:** [October 12, 2022, 2:26pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-33/46826/30 "2022-10-12T14:26:15Z")
Hello Victor, thanks for your answer 😉 Good to know that the data have changed. I try to run the workflow with your hint, regarding: “the relative path with current workflow data area will only work”, but I strruggle. I have in my workflow folder the folder called “data” and I try the relative setting from the Youtube video, but it doesn’t find the files, no matter which relative setting I use, see screenshots. Also no matter if I choose files or folders. Could you please send me a screenshot how I have to setup this note that it will work. Thanks in advance BR FlowCreator ![Error4 - Relative Setting](https://forum-cdn.knime.com/uploads/default/original/3X/b/9/b90ce79a9b7866b5da4b97ca8c248d3fd018c0d9.png) ![Error3 - Relative Setting](https://forum-cdn.knime.com/uploads/default/original/3X/0/0/004999e9b3ec452da7ac38f44ac2f47c3ce14d64.png) ![Error2 - Relative Setting](https://forum-cdn.knime.com/uploads/default/original/3X/f/3/f3f401482e4e2f829ded704e636b5b875addfe65.png) ![Error1 - Relative Setting](https://forum-cdn.knime.com/uploads/default/original/3X/e/4/e46fad08a4e5ae65f4136768a62042fce8da6328.png) ![Data Folder](https://forum-cdn.knime.com/uploads/default/original/3X/0/3/03294a6dcf96a21d562a542606c178bec4fdda6b.png) ---
**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\ **Post date:** [January 10, 2023, 2:26pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-33/46826/31 "2023-01-10T14:26:29Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed. [Previous page](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-33/46826.md?page=1)