I need some help to generate an archive with some conditions:
- I have an unique code with 2 columns that can match up to three other codes, for example:
Unique Code | EAN
VX0004 | 123
VX0004 | 456
VX0004 | 789
- These Unique Codes are associated to a store sell out in a determined day and with a certain value (4 columns). Example:
Unique Code | CNPJ | Data | Valor
VX0004 123456 27/03/2023 14,49
My main goal is to have something like this in the final output (3 columns):
EAN | CNPJ | Data |
123 | 123456 | 27/03/2023
456 | 123456 | 27/03/2023
789 | 123456 | 27/03/2023
Thanks in advance!
Hi I probably don’t get your question correctly as I looks like joining to tables together based on unique code.
I hope someone else can help
First of all, thanks for the reply.
For some reason i can’t download Vlookup extension. Do u know how can I do that?
When i entered knime, it asked to download all extensions but it can’t conclude.
Hi @lawrencetu , Value Lookup is new in KNIME 5.1 so in earlier versions you will need to replace it with other nodes.
In this case, I believe the suitable replacement for 4.x would be duplicate row filter and joiner:
On the duplicate row filter, make it unique on uc
In the joiner, join on uc2 = uc, and return Matching and Left unmatched rows. This should then give the same output as the Value Lookup in @marzukim 's workflow.
@marzukim you might want to check that this would give the same results that your existing workflow gives
thank you for clarifying the node replacements. i’ve just noticed today that they are not included in the base 4.7 extension hope our @lawrencetu will be able to run the workflow with your recommendation.
i’ve run the amended vlookup replacement with (duplicate and joiner nodes) and it works well. i hope it meets @lawrencetu 's expectations.
thank you again for your help, sifu @takbb . you are the true problem solver!
Hey @marzukim and @takbb!
Am I doing right?
Hi @lawrencetu , I’ve not looked at the specifics of what the workflow does but from the message I’d say that the Table Row to Variable node needs to be configured to include “uc2”
@lawrencetu, apologize for not attaching the revised version. please find it attached.
KNIME_combine_analysis_v2.knwf (97.6 KB)
Thank you both @markzukim and @takbb!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.