I want to join 2 datasets but one of them have values with comma

[maanvendra]

I want output table as

This is urgent pls.

[ipazin]

Hello @maanvendra,

there are multiple ways to achieve this. One would be to use Cell Splitter on Input table 1 to get every value in single cell, then use Unpitoving node to have all values in one column, apply your logic using Joiner or Cell Replacer node and finish it with Pivoting node to get desired output.

Check above explained approach here:

Replace Values over Multiple Columns – ipazin

Br,
Ivan

[maanvendra]

Can you please provide the workflow for it.
Im able to. use cell splitter to get grouped values to individual record and then join with 2nd table.

The problem is to again get those records to single row with comma separated.

[takbb]

Hi @maanvendra

Here’s another method which splits out the comma separated lists into individual rows by combination of Cell Splitter and ungroup. After joining, it then regroups based on a counter value which represents the original row that the values were grouped on.

joining comma separated data sets.knwf (20.4 KB)

[MartinDDDD]

The pace at which people reply is incredible :-).

Here’s my take at this:

Matching_Fragments – martindddd

[maanvendra]

Hi @MartinDDDD , your final output is not something im looking for it is giving the same output as input

[ipazin]

@MartinDDDD Just a tip: you can use option Skip rows containing missing cells in Unpivoting node so you don’t need Missing Value node.

@maanvendra he just used wrong column in GroupBy node. Replace it with column holding letters and you’ll get desired output.

Br,
Ivan

[MartinDDDD]

@maanvendra

your final output is not something im looking

Ups - accidentally grouped the wrong column. Fixed and re-uploaded. Good pickup.

[MartinDDDD]

@ipazin

@MartinDDDD Just a tip: you can use option Skip rows containing missing cells in Unpivoting node so you don’t need Missing Value node.

Mind-blown for today Thanks for the tip

[maanvendra]

Thanks all for such a quick reply. Wonderfull community.

I find @MartinDDDD & @takbb, solutions to my liking.

Thanks again.

[takbb]

You’re welcome @maanvendra . There’s often a variety of approaches and great to see a few different ones here.

[gonhaddock]

Hello @maanvendra
I’m late to the discussion, but alternatively; you can approach the replacement with ‘Dictionary Tagger’ node. I think it is a cleaner method for your use case as you won’t need to disaggregate or manipulate the text.

Text Processing _ Multiple String Replacement in Text from Dictionary –...

BR