1

So my problem is all values are NULL if I join my CSV table to a point shapefile, why? (QGIS)

I tried so many things but I cannot find and handle the problem. I have customer names in the CSV, account numbers as well, digits and letters.

OK, I put a screenshot here, that is maybe better to see what I mean.

enter image description here

closed as off-topic by underdark May 28 '15 at 20:10

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions describing a problem that can't be reproduced and seemingly went away on its own (or went away when a typo was fixed) are off-topic as they are unlikely to help future readers." – underdark
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 2
    Welcome to the site Juli. You will likely need to include (as an edit to this post) more information including screenshots and a description of the steps that you took in order to get a good answer. Please see these links to get you started here: gis.stackexchange.com/help/how-to-ask and gis.stackexchange.com/tour. – Aaron May 28 '15 at 15:09
  • Do both your csv file and your point shapefile have a common attribute that you are joining? – Joseph May 28 '15 at 15:27
  • yes it looks like this 'D00 045' in both columns. this are account numbers – Juli May 28 '15 at 15:39
  • Or is there somebody who knows which kombination can I use in the field-calculator to delete the space in the number like this 'D00 0054' ??? that would be also interesting – Juli May 28 '15 at 15:54
  • Could you also include the exact steps that you used to do the joins? – Aaron May 28 '15 at 16:26
1

So now I got it. I tried something else. I wanted to remove the space out of the numbers which are these ID to join the csv.

I could delete the space with the field-calculator, the funnction for that is replace("text",' ','') so and then the space was deleted. then I joined the csv and dadada it works. the values are all there, not NULL anymore.

Thank you very much all of you for your help!!!keep it up

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