# Solutions to "Just KNIME It!" Challenge 15 **URL:** \ **Category:** Just KNIME It!\ **Created:** [May 4, 2022, 1:03pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482 "2022-05-04T13:03:56Z")\ **Posts on this page:** 20\ **Page:** 1
**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:** [May 4, 2022, 1:03pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/1 "2022-05-04T13:03:56Z")
This thread is for posting solutions to “Just KNIME It!” Challenge 15 (yes! 15 challenges already!!). Feel free to link your solution from [KNIME Hub](https://hub.knime.com/) as well! Here is the challenge of the week: [Just KNIME It! | KNIME](https://www.knime.com/just-knime-it) Have an idea for a challenge? We’d love to hear it! 😍 Feel free to write it [here](https://forum.knime.com/t/community-just-knime-it-challenges/40506/5). And remember: the more you participate, the more [participation badges](https://forum.knime.com/t/just-knime-it-badges/41080/2) you may end up getting. Fancy, huh? 😉 Just remember to correctly mark your solution in the Hub with tag **justknimeit-15**. 😁 ---
**Author:** ![sryu](https://forum-cdn.knime.com/user_avatar/forum.knime.com/sryu/32/60147_2.png) [@sryu](https://forum.knime.com/u/sryu)\ **Post date:** [May 4, 2022, 3:55pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/3 "2022-05-04T15:55:05Z")
This is my first post. [Just KNIME It-15](https://hub.knime.com/sryu/spaces/Public/latest/Just%20KNIME%20It/justknimeit-15~-TgCzl9W-GSriRIs) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/1/31192a31ebd76447e6831a6bd7d8dfb3074ce230.png) ---
**Author:** ![AnilKS](https://forum-cdn.knime.com/user_avatar/forum.knime.com/anilks/32/52258_2.png) [@AnilKS](https://forum.knime.com/u/AnilKS)\ **Post date:** [May 4, 2022, 6:20pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/4 "2022-05-04T18:20:38Z")
My Take on Challenge 15.Bit lengthy though with 10 Nodes . > **[Just Knime It-CH15 – anilks](https://hub.knime.com/anilks/spaces/Public/latest/Just%20Knime%20It%20Challenge/Just%20Knime%20It-CH15~6YRF7kRgsUcvu2aX)** > > Solutions for data science: find workflows, nodes and components, and collaborate in spaces. ![Capture](https://forum-cdn.knime.com/uploads/default/original/3X/a/9/a97e3cdc82a9acd96a02bfc943be9680575a0700.png) ---
**Author:** ![Andrew\_Steel](https://forum-cdn.knime.com/user_avatar/forum.knime.com/andrew_steel/32/4472_2.png) [@Andrew\_Steel](https://forum.knime.com/u/Andrew_Steel)\ **Post date:** [May 4, 2022, 9:24pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/5 "2022-05-04T21:24:06Z")
[This](https://kni.me/w/sO3h6ABeEJzXAShH) is my solution: ![Bildschirmfoto von 2022-05-04 23-22-26](https://forum-cdn.knime.com/uploads/default/original/3X/9/2/92c18711415ceaecc5bc27f3076dc79613840a9e.png) ---
**Author:** ![elsamuel](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/e/b4bc9f/32.png) [@elsamuel](https://forum.knime.com/u/elsamuel)\ **Post date:** [May 4, 2022, 11:55pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/6 "2022-05-04T23:55:08Z")
Here’s my attempt: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/c/0cf9f22b4ed8bdda9a3c05d5475ec69f701a38d0.png) > **[elsamuel/Public – Challenge 15](https://hub.knime.com/elsamuel/spaces/Public/latest/Just%20Knime%20It/Challenge%2015~Gvg87V0dzlPoKV3e/)** > > contains 2 items ---
**Author:** ![lelloba](https://forum-cdn.knime.com/user_avatar/forum.knime.com/lelloba/32/43992_2.png) [@lelloba](https://forum.knime.com/u/lelloba)\ **Post date:** [May 5, 2022, 8:51am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/7 "2022-05-05T08:51:22Z")
Hello Knimers, this is my solution: [justknimeit - 15 - Raffaello Barri – KNIME Hub](https://kni.me/w/s2uM58PaR7R1o4g2) I added a variable, so that the table to be read can vary in lenght. Also, I read the columns up to the last one. Have a nice day, RB ---
**Author:** ![myxiao](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/ecae2f/32.png) [@myxiao](https://forum.knime.com/u/myxiao)\ **Post date:** [May 5, 2022, 12:35pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/9 "2022-05-05T12:35:08Z")
My solution with 10 nodes: ![Screenshot15](https://forum-cdn.knime.com/uploads/default/original/3X/c/2/c29f864db23ff27375a91c213e1f2c0b720b6737.png) > **[Challenge 15 Extracting a Table from a PDF – myxiao](https://hub.knime.com/myxiao/spaces/Public/latest/Challenge%2015%20Extracting%20a%20Table%20from%20a%20PDF~lt14SJlywObvNv7B)** > > Solutions for data science: find workflows, nodes and components, and collaborate in spaces. ---
**Author:** ![martinmunch](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/8dc957/32.png) [@martinmunch](https://forum.knime.com/u/martinmunch)\ **Post date:** [May 5, 2022, 2:26pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/10 "2022-05-05T14:26:50Z")
Here’s my solution Did two versions. One where I tried to automate as much as possible i.e. 1. download of PDF 2. Dynamically parse data table based on search key 3. Dynamically parse single row headers. Second version I tried to limit no. of nodes sacrificing the dynamic part. I managed solving the challenge using 8 nodes. ![image](https://forum-cdn.knime.com/uploads/default/original/3X/1/b/1b9991ad32171a6a7a661545f53e8eedd3ae17af.png) > **[KNIME\_challenge15\_solution – martinmunch](https://hub.knime.com/martinmunch/spaces/Public/latest/KNIME_challenge15_solution~9_xp-TzjD1KGa7tC)** > > Challenge 15: Extracting a Table from a PDF Level: Hard Description: Given a text-based PDF document with a table, can you partially extract the table into a K… cheers ---
**Author:** ![walkergv77](https://forum-cdn.knime.com/user_avatar/forum.knime.com/walkergv77/32/39486_2.png) [@walkergv77](https://forum.knime.com/u/walkergv77)\ **Post date:** [May 5, 2022, 5:17pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/11 "2022-05-05T17:17:40Z")
Fun little test. Here is my submission I did it in 7 nodes. I will admit I came up at first with same solution as @elsamuel so I went back and see if I could try something different. So I cheated the insert header column by exporting to csv without the header and reading it back in saying it had a header. I split on spaces and used the transform in the csv reader to eliminate columns and get numbers typed correctly as integers. Two executes but it gets you there. **[Link to solution on KNIME Hub](https://kni.me/w/3bcHjxCIzntnfzV-)** ![image](https://forum-cdn.knime.com/uploads/default/original/3X/c/c/ccfe34ad0774aeb1aaca4f15c86695959ac552bf.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:** [May 5, 2022, 5:49pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/12 "2022-05-05T17:49:14Z")
Yay! We appreciate your participation, @sryu. ---
**Author:** ![ersy](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/e/71c47a/32.png) [@ersy](https://forum.knime.com/u/ersy)\ **Post date:** [May 6, 2022, 7:43am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/13 "2022-05-06T07:43:15Z")
Hi everyone, here is my solution I kept the last rows (sum ,avg) but it can be easily removed. > **[justKnimeit-15 – ersy](https://hub.knime.com/ersy/spaces/Public/latest/justKnimeit-15~gO8whCv92nxasrYU)** > > Challenge 15: Extracting a Table from a PDF ---
**Author:** ![eamendola](https://forum-cdn.knime.com/user_avatar/forum.knime.com/eamendola/32/36540_2.png) [@eamendola](https://forum.knime.com/u/eamendola)\ **Post date:** [May 7, 2022, 10:21pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/14 "2022-05-07T22:21:58Z")
Hello everyone ! My solution to this very interesting challenge. I processed the input a bit further so we can have the full table to analyze ! ![image](https://forum-cdn.knime.com/uploads/default/original/3X/5/a/5a552a8c677195ea359ba8c5085ab150d01f627f.png) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/2/f/2f283012d80c66d8ddf2d264bb15ccf6ffa05b93.png) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/e/2/e20a500b80bd0dce3ce0262c2640be76f1bc0a77.png) > **[Challenge 15 - Extracting a Table from a PDF – eamendola](https://hub.knime.com/eamendola/spaces/Just%20KNIME%20it%20!/latest/Challenge%2015%20-%20Extracting%20a%20Table%20from%20a%20PDF~1VL73u2-QFt_GWmH)** > > Parse a PDF so you can convert it to a more friendly table to analyze ---
**Author:** ![elimisael](https://forum-cdn.knime.com/user_avatar/forum.knime.com/elimisael/32/63413_2.png) [@elimisael](https://forum.knime.com/u/elimisael)\ **Post date:** [May 8, 2022, 12:20am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/15 "2022-05-08T00:20:39Z")
[![image](https://forum-cdn.knime.com/uploads/default/original/3X/b/5/b5070c4302c403f92dec8e362ddefc5896fdf23b.png)](https://hub.knime.com/elimisael/spaces/Public/latest/Just%20Knime%20It/justknimeit-15~eaFy3al6h1XDkerz/) This is my solution, it is partly based on what was done by @walkergv77 and @Milks, each proposal has problems with its solutions. [Just Knime it - 15](https://hub.knime.com/elimisael/spaces/Public/latest/Just%20Knime%20It/justknimeit-15~eaFy3al6h1XDkerz/) @AnilKS generates a mistake when splitting, and the final result show, that it is not present the exact columns requested on the challenge. ![image](https://forum-cdn.knime.com/uploads/default/original/3X/a/f/af4e09d67ab19323af4516621d9de8c773faf909.png) @walkergv77 when writing the solution to XLS, include the AVG column and omit the COOL column ![image](https://forum-cdn.knime.com/uploads/default/original/3X/8/c/8c74bd33ef0f03fec8b372aea7a61e38aac2c569.png) ---
**Author:** ![badger101](https://forum-cdn.knime.com/user_avatar/forum.knime.com/badger101/32/45755_2.png) [@badger101](https://forum.knime.com/u/badger101)\ **Post date:** [May 8, 2022, 1:12am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/16 "2022-05-08T01:12:36Z")
Wow, that’s an awesome workflow. Easy to understand and work with! @elimisael ---
**Author:** ![tafarouk](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tafarouk/32/35607_2.png) [@tafarouk](https://forum.knime.com/u/tafarouk)\ **Post date:** [May 8, 2022, 1:24pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/17 "2022-05-08T13:24:55Z")
I have extended it to all available columns in the table.I used regex to fix irregularity in direction column. > **[Challenge 15 - Extracting a Table from A PDF – tafarouk](https://hub.knime.com/tafarouk/spaces/Public/latest/knime%20it%20challenges/Challenge%2015%20-%20Extracting%20a%20Table%20from%20A%20PDF~BznEW9l2OPW5XPEu)** > > Just KNIMEit challenge 15 ... extracting a table from a PDF file ---
**Author:** ![MEPivnenko](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mepivnenko/32/36596_2.png) [@MEPivnenko](https://forum.knime.com/u/MEPivnenko)\ **Post date:** [May 9, 2022, 10:58am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/18 "2022-05-09T10:58:12Z")
10 nodes as requested. No cheating. > **[KnimeIT\_15 – mepivnenko](https://hub.knime.com/mepivnenko/spaces/Public/latest/KnimeIT_15~FGIF0GyStwr4ZoZF)** > > Solutions for data science: find workflows, nodes and components, and collaborate in spaces. ---
**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:** [May 10, 2022, 1:59pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/19 "2022-05-10T13:59:29Z")
As always on Tuesdays, here’s our solution to #justknimeit challenge 15! 🤓 > **[Extracting a Table from a PDF – alinebessa](https://hub.knime.com/knime/spaces/Just%20KNIME%20It!/latest/Challenge%2015%20-%20Extracting%20a%20Table%20from%20a%20PDF%20-%20Solution~1uIrwPPiVwP-r-v5)** > > Given a text-based PDF document with a table, can you partially extract the table into a KNIME data table for further analysis? For this challenge we will extr… I hope you learned something useful this week! In my opinion this is data wrangling at its finest hehe See you tomorrow for a new challenge! ---
**Author:** ![gonhaddock](https://forum-cdn.knime.com/user_avatar/forum.knime.com/gonhaddock/32/35425_2.png) [@gonhaddock](https://forum.knime.com/u/gonhaddock)\ **Post date:** [May 10, 2022, 8:24pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/20 "2022-05-10T20:24:11Z")
Hello KNIMErs, it’s better late than never! Here is my solution to #justknimeit-15 : KNIME Hub \> gonhaddock \> Spaces \> Just\_KNIME\_It \> [Just KNIME It \_ Challenge 015](https://kni.me/w/twZHLmfdChxfnJPN) It’s been unavoidable to get insights from previous solutions (thanks for it). Specially the cool Cell Splitter to list and Ungroup… great to apply here. BR ---
**Author:** ![cf\_123](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/c/a88e57/32.png) [@cf\_123](https://forum.knime.com/u/cf_123)\ **Post date:** [May 11, 2022, 9:03am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/21 "2022-05-11T09:03:51Z")
Here my solution: [jKi-15 – KNIME Hub](https://hub.knime.com/cf_123/spaces/Public/latest/jKi-15) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/1/4/141d365c247556a0686a35d70db97f40d9f10c48.png) ---
**Author:** ![elimisael](https://forum-cdn.knime.com/user_avatar/forum.knime.com/elimisael/32/63413_2.png) [@elimisael](https://forum.knime.com/u/elimisael)\ **Post date:** [May 11, 2022, 5:47pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482/22 "2022-05-11T17:47:32Z")
Great solution, but the final result doesn’t show the columns requested on the challenge, at final exclude them. Look ![image](https://forum-cdn.knime.com/uploads/default/original/3X/4/c/4c6706b8d69f993d7df10ad4a8b0e7cbe434406c.png) [Next page](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-15/42482.md?page=2)