Forum Discussion
Tableau décalage
If these are simple links they actually mean that you take values from Y files in accordance to their row-column coordinates. If you reorder these data it affects A:D in file X, values appear here in another order but actually you don't sort records in X. Since data in columns from F are not connected to A:D data they stay in their own place independently on which values are returned by links.
Actually you need manually enter data in some column into both files, that could be person ID. Based on it you may lookup (XLOOKUP, whatever) other data which are now in A:D. Independently of sorting Y it always returns the same data based on ID. Data from F also will be connected to ID since they are in the same record and ID is entered manually. With that you may sort/filter X and Y independently.
annesophieplourde Can't be certain from just looking at the pictures, but you have hidden column E. If that one is empty, sorting columns A to D will not be synchronised with columns F to H.
If these are simple links they actually mean that you take values from Y files in accordance to their row-column coordinates. If you reorder these data it affects A:D in file X, values appear here in another order but actually you don't sort records in X. Since data in columns from F are not connected to A:D data they stay in their own place independently on which values are returned by links.
Actually you need manually enter data in some column into both files, that could be person ID. Based on it you may lookup (XLOOKUP, whatever) other data which are now in A:D. Independently of sorting Y it always returns the same data based on ID. Data from F also will be connected to ID since they are in the same record and ID is entered manually. With that you may sort/filter X and Y independently.
- Thank you ! Merci ça a fonctionner
annesophieplourde Then I don't know. Can you upload your file?
