I am working with the "Joins" option in QGIS 3.10, which joins the fields from two attribute tables based on a common shared attribute column.
However, this does not work for attribute values with a large length.
E.g. the following field value can be joined: 2404252385
While this one cannot: 551482643342511892418838370
I checked carefully if it may be due to other problems, but it clearly seems to be the problem of the number of characters. For example, I can filter both features by the attribute fields, which returns the respective row. However, the joined fields nevertheless show 'NULL', i.e. the common field name could not be found.
Can somebody confirm this problem and is there maybe a workaround/solution to fix this?
Edit: I am referring to field values, not field names. I tested around and possible issues that might be the problem are:
- The columns that I want to join are both called "fid"
- The columns that I want to join are of type string, not integer