Hi,
I have two large data set as per stated model. I needs to bring the filed1 from dataset-1 to dataset-2 with the condition that the value of filed 1 should be in between from "Value From" and "Value To" in Dataset-1. Please help me.
Solved! Go to Solution.
Hi @Syam_Alfuttaim,
You could append the tables and filter for where results are between your to and from values, i mocked up my own sample data but the same principles should apply:
The formula I used in the filter:
[Field2] >= [ValueFrom]
AND [Field2] <= [ValueTo]
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
Regards,
Jonathan
Hi @Syam_Alfuttaim another way to do this would be with a generate rows tool setup like this to fill between your from and to values:
Then if you join the created field onto the second data source you'll get your answer
Hope that helps,
Ollie
Hi,
Thank for your replay. However please note my datasets so large as I cant use "Append Fields" tool as it limited to 16 values. Please find stated and requesting to suggest another solution.
This is an option that can be disabled in the tool itself. Look for the drop down menu at the bottom.
is the "DataSet 1" fixed i.e is it a fixed reference from A to Z? I also noticed that B should have the "Value To" 16 not 15 if this is a fixed reference table.
Dataset-1 values not necessary to be continues from the previous.