Is there a way to check if the variable is in the right position? I do not want to reorder the position of the columns. If table a is correct. Then, table b with 'site' column in the first column and 'subjid' column in the second will be incorrect. How do I flag the incorrect position of the variables or send the incorrect dataset through pass/fail port? Is there a component that I can check variables' positions? Related question, if there are only supposed to have two variables(subjid and site). Then, how can I flag the dataset (such as send the whole dataset to either fail or pass port)when there are more than two variables or less than two? Thank you for reading this long questions!
table a
subjid site
1234 a
5678 b
table b
site subjid
a 1234
b 5678
