1

I have a CSV file which I would like to join to a TAB file.

The TAB file has the table structure shown below. The column PLAN_NO is the unique reference in this table.

enter image description here

The CSV file has the table structure shown below. The column TILE_REF is the unique reference in this table.

enter image description here

When the two columns PLAN_NO and TILE_Ref match I'd like to update the column EA_1M_DSM in the TAB file with the letter 'Y'.

How do you do this in QGIS?

2
  • Are you asking for the concept/workflow, or how you write "Y" in the new column?
    – Erik
    Jan 15, 2020 at 9:55
  • can you illustrate the tables and what do you want ? Jan 15, 2020 at 9:55

1 Answer 1

3

Use the field calculator. First, do the join, then an expression like this into the 'EXISTS' field should work:

CASE
WHEN "TILE_REF" = "PLAN_NO" THEN 'Y'
ELSE ''
END

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.