Help on Exercise "L1-AP Data Literacy with KNIME Analytics Platform"

KNIME Analytics Platform
,
1

Hello,

For the L1-AP Data Literacy with KNIME Analytics Platform - Basics exercise, on section 4.1 for the value lookup node, after I add this node I found all the columns except the StoreType ?

Thank you…
Regards,

2

Hi @Abeer_2030,

It would be helpful if you can share your workflow to understand the issue better.

Best,
Keerthan

2 Likes
3

hello Shetty,

thank you very much Sir.
the problem is when I apply the exercise named “L1-AP Data Literacy with KNIME Analytics Platform - Basics” on section 4.1, when adding the value lookup node, after I add this node I found all the columns except the “StoreType” column, where what I need exactly is to have just the “StoreType” column without any other column. you can check the below image on the “includes” section below. I want to have just the “StoreType” column on the list based on the exercise solution without any other column. So, why it’s not there!

11
111919×1037 182 KB

4

The second input of the Value Lookup node is the dictionary table. Make sure you’ve connected the correct input there—otherwise it won’t appear in the configuration dialog.

image
image1212×661 84.9 KB

1 Like
5

Customer Transactions Analysis - Solution.knwf (175.4 KB)

hello Shetty,

check the attach document please.

thanks in advance…
regards,

6

Hi,

I am able to see the store type in the value lookup from the workflow you provided. Can you share your solution instead of the exercise solution.

Best,
Keerthan

8

Thanks you for your replay. However, It seems that I am not connected correctly. should I download any software to support the files extension related to this exercise!

22
221997×1019 188 KB

9

You don’t need to download anything separately. The DB Table Selector node is used only to select the table (you can also run your custom SQL query)—you won’t see any data at that stage. To actually retrieve and view the data in your workflow, you’ll need to use the DB Reader node.

The Fetch Data option you’re seeing just previews the first 100 rows of your database table. It’s for inspection only and does not bring the data into the workflow for further processing.

Check this out : Querying Databases in KNIME Analytics Platform

10

Thanks Shetty. However, this is not answering my main question regarding “StoreType” element!

11

Please connect the table that contains the store type column to the bottom input of the Value Lookup node. Based on your first screenshot, it looks like you’ve connected the output of the DB Reader node there instead, which may not contain the necessary column for the lookup.

12

Thank you very much. It’s working well now. However, I found a new issue on the DB “Table Selector node”, I cannot press the execution button it’s not active!

Thanks again…
regards,

23
231823×964 99.3 KB

13

Hi,
you have to rerun the SQLite Connector as it lost his connection (that’s why there is a " ! " mark. (I know it’s not really self explaining)

image

To avoid this in the future can can adjust the setting in the “SQLite Connector” like following:

image
image1003×831 144 KB

2 Likes
14

Thanks. Do you know why the “Visualization” node not exist? I cannot found it to apply the section 6.3 for the same exercise?

15

Could you please elaborate more? is this mean I cannot visualize the data currently? or this is related to the paid versions?

16

Hi @Abeer_2030,

The visualization node you are referring to is not acyually a node but a component.

To learn more about components, I recommed you the following resources:

Best,
Keerthan

1 Like