Bending my head around which nodes allowing me to add
the column
Table B,Row R, Col2
“additional value”
to
Table A, Row P, Col 1
“Some string with an identifierXYZ”
where
Table B, Row R, Col 1
“identifierXYZ”
is a substring?
Bending my head around which nodes allowing me to add
the column
Table B,Row R, Col2
“additional value”
to
Table A, Row P, Col 1
“Some string with an identifierXYZ”
where
Table B, Row R, Col 1
“identifierXYZ”
is a substring?
Hi there!
It is a substring() function I would use as well and afterwards Joiner or Cell Replacer node to add column.
A question is how to get identifier out of “Some string with an identifierXYZ”. I used indexOf() function in String Manipulation node but it maybe won’t work in every case you have so think about it.
Here is workflow attached if you want to check settings.
AddColumnWithSubstring.knwf (23.4 KB)
Have a nice day!
Ivan
Looking good, thank you.
But if I require the full string “identifierYZ” from table B to be used for search on all rows of table A for a substring match?
Hey Ivan,
regexReplace($StringIdentifier$, "\\w+\\b (?<!identifier[0-9]{1,3})", "")
Best,
Armin
Hi there!
Have you downloaded the workflow and checked it cause it seems to me that the workflow is doing it already. If not can you give me an example?
Br,
Ivan
Hmmmh, perhaps I’ve interpreted it wrong … will apply to my flow and let you know
Sure. If any questions just aks.
Ivan
Hi @ipazin, sorry … took me a while to get back.
I am still struggling. Your flow identifies the matches by search on TableA.
I am looking for a solution to
search a col in TableA for contents of a col in Table B (am able to get so far, see updated sample attached )
and then append another col’s contents from TableB for all hits to TableA << this is what I do not find a solution for
Perhaps the rephrased description above helps to identify one
AddColumnBySubstring.knwf (16.2 KB)
Hi @kopfkino !
Not sure what are you trying to accomplish. Can you provide an example of input tables and wanted output table?
Br,
Ivan
Sure, find a sample attached to the previous post
Hi there!
So the input tables are in Table A and Table B? And what should be the output?
Br,
Ivan
Hey Ivan, thanks for the swift reply.
The output I am looking for would be Table A plus the additional value from B in an extra column for each row where the identifier does match.
Hi there!
Here is modified workflow. If I got you right this should do the trick
2019_04_09_AddColumnBySubstring.knwf (21.1 KB)
If any questions feel free to ask.
Br,
Ivan
Exactly the tree I was about to climb and doing the trick
Thank you