Hi,
I have a (input) dataset of the form as below wherein I have an input data column called Data which I want to match/compare against the other columns (1-4)
Input Data
What I want essentially is a subset columns for eg in this case Data is matching with column 1, so I only want to output column 1.
Output Data form-I want to keep the column called 1 and not the column called Data
Looking for a dynamic solution since my " Data" column details could change depending on user input (app) and could match details of column "2" in which case my output should be column "2" only.
I may have some stagnant columns x,y,z in input which I want to keep as an output irrespective.
I tried to implement it using multifield and join tool-I guess multi row and multi field might be required together-not sure how to go about this-any help on this is appreciated.
Solved! Go to Solution.
Find in attachement the way of doing this.
It can work with as many fields as you want. 🙂
Let me know if there is any issue and do not hesitate to mark this answer as solution if it works.
This is awesome ! Thanks as lot @Emmanuel_G :)