[Qgis-user] How to get rid of table name while joining table

Matthias Kuhn matthias.kuhn at gmx.ch
Thu Jan 22 07:39:20 PST 2015


I just merged this functionality.
When you create a join, you may specify a prefix. This can be an empty
string.
By default it is unspecified and "layername_" is used, so it is exactly
like before.

Best,
Matthias

On 20.01.2015 11:25, Nathan Woodrow wrote:
> I think leaving it up to the user is the best option here.
>
> Nathan
>
> On Tue, 20 Jan 2015 8:17 pm Andreas Neumann <a.neumann at carto.net> wrote:
>
>>  Then you can't distinguish a joined column from a normal column. And it
>> would open up naming conflicts - which is the reason why the layer name
>> prefix was introduced. Bad, in my opinion.
>>
>>
>> Andreas
>>
>>
>> On 20.01.2015 11:01, Harish wrote:
>>
>>  Thanks for kind replies. A feature request for adding an option to
>> not prepend layer names will be better.
>>  Regards
>>
>> On Tue, Jan 20, 2015 at 3:18 PM, Andreas Neumann <a.neumann at carto.net>
>> wrote:
>>
>>> or - the even better way would be to allow the user to define a very
>>> short user-defined table name prefix (1-3 chars).
>>>
>>> Andreas
>>>
>>>
>>> On 20.01.2015 10:45, Anita Graser wrote:
>>>
>>>>  On Tue, Jan 20, 2015 at 9:41 AM, Harish <harry.om2000 at gmail.com> wrote:
>>>>
>>>>> I do not want name of table to be included in attribute names when
>>>>> joining
>>>>> tabular data to vector layers which are further truncated when saving
>>>>> the
>>>>> layer permanently.
>>>>>
>>>> Hi Harish,
>>>> Layer names are prepended to avoid troube with columns having the same
>>>> name (often the case with "id" or "name" columns).
>>>> You can change the layer name to empty, then only an underscore _ will
>>>> be prepended - this saves characters.
>>>> An alternative is to open a feature request for adding an option to
>>>> not prepend layer names.
>>>> Best wishes,
>>>> Anita
>>>>  _______________________________________________
>>>> Qgis-user mailing list
>>>> Qgis-user at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>>
>>  _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user




More information about the Qgis-user mailing list