Interactive selection on the same table

[Claire]

Hi,

I need to select 2 rows within the same table but the first selection should remove the selected row so that it cannot be selected twice.

Can I do that using 2 table view nodes in the same component? My attempts are not successful so far…

Thanks,

Regards,

Claire

[mehrdad_bgh]

Hi Claire,

I don’t fully understand your question. Can you explain more? You HAVE to select 2 rows in two different selections? Why don’t you select them at once?
Please upload your workflow.
And about 2 table view nodes in same component, check this:

Interactive JS Nodes On Different Tables

Let me explain what I’m trying to do. Im sure it can be done I just can’t figure out how. I have a table with customers showing in a table view node. When user selects a custom in that table, I want the table below to show me all the videos they rented. So because these are two different tables without matching rowid’s I can’t see how to do this with publish/selection events.

Mehrdad

[Claire]

Hi Mehrdad,
The table I use contains only one column (column names from the Extract table spec node). Based on the selected names I want to swap data in these 2 columns: values in column A are replaced with value from column B. It is a mapping table. Therefore, I cannot do the selection in the same table. The same column name cannot be selected twice.
Regards,
Claire

[mehrdad_bgh]

Hi Claire,

You want something like this?:
KNIME_project5.knwf (11.7 KB)

[Claire]

Hi Mehrdad,

Well, in the second view I would like to get all rows from previous view with the exception of the selected one.
In your exemple, I have a,b,c,d entries in the first view. If I select b, I would like to get only a,c,d in the second view.
I select only one entry in each view.

Thanks,
Cl

[mehrdad_bgh]

Hi Claire,

So it worked for you?

Or I’m missing something?
Please note that in first view all the values are in Include table at starting, and you have to select your value by transferring it to Exclude table.
Let me know if it’s what you are looking for.

Br,
Mehrdad

[Claire]

Hi Mehrdad,
Yes, it does the job for the second selection (I got the selected row using the ‘true’ value). But for the 1st selected value how do I get the excluded value (which is in fact the value I should keep for further processing)?
Well, I have implemented a workaround actually. I am using 2 list boxes and put code behind. Not perfect but it works….
Thanks a lot for your help. I will keep your example for future use.
Regards,
Claire

[mehrdad_bgh]

Hi Claire,

Use filter apply and reference row filter and in reference row filter’s config select Exclude rows from reference table.

BTW I know excluding staff is not a very clean way but you can write a description for it.

GL,
Mehrdad