I am having an issue in qgis table joins. i have a joined a csv file to a sqlite database and common id is used for join. the join is displays correctly in attribute table.
the attributes in sqlite file is id and the csv file has id, building, surveyorid, surveydate. I want to add the surveydate information to the sqlite data permanently.
In the field calculator. i created a new field survey_date.
the expression field is "surveydate" (field from csv file), the output preview displays the result correctly.
The problem is on clicking ok, the new field(survey_date) gets populated with values of surveyorid. I tried other cases and each time, the new field gets populated with values from the field that is before the field in expression, i.e. if i try with surveyorid, i get the building values.