Forum Discussion
Impactful IndividualFiled contents disappearing ????
Ok I found it but it makes no sense.
The data i'm using is coming form microsoft Dynamics. There are 2 fields cha_gender which is a numerical field 12664000 which means male. There is another field cha_gender_display which shows the value of this number as male. If I only hav ethe display field in thetable then sorting/filtering wipes out thew value. If I have both fields it doesn't. Same for al lfields that are stored as numbers, but have text display values.
Its as if sorting/filtering is forcing a relokup but becuase the numericla field is in the data it returns a null i.e. the text i'm seeing is not actually a real piece of data. As long as i remove the numericla fields right at the end it looks ok. Data is coming ofrm a CDS feed
Impactful IndividualI have double checked and only one row with this account number in the source
Thisis the view at source level. You can see Mr Ainscow at the bottom
Now just filter for his account number
It seems sorting or filtering the source just wipes out these fields
Impactful IndividualOk I found it but it makes no sense.
The data i'm using is coming form microsoft Dynamics. There are 2 fields cha_gender which is a numerical field 12664000 which means male. There is another field cha_gender_display which shows the value of this number as male. If I only hav ethe display field in thetable then sorting/filtering wipes out thew value. If I have both fields it doesn't. Same for al lfields that are stored as numbers, but have text display values.
Its as if sorting/filtering is forcing a relokup but becuase the numericla field is in the data it returns a null i.e. the text i'm seeing is not actually a real piece of data. As long as i remove the numericla fields right at the end it looks ok. Data is coming ofrm a CDS feed