Combining two CSV files via same group Attributes

   1354   3   0
User Avatar
Member
1 posts
Joined: April 2019
Offline
Hello,

this is my first post here & I am currently learning to use Houdini at my university for the first time.
I hope you could help me with my specific question:

I wanted to connect two CSV files with different information together.
One CSV File contains information on various cities via long/lat and the other one contains informations I want to display at those specific locations. They both have only one row in common “countrycode”.

Is there a way to connect both of them via “pointwrangle”?

I have attached the hipnc file with the part I needed help on and the two CSV files.

Hopefully someone could help me solve this problem. I am happy with any advice and/or link to a tutorial I could study!

Best wishes!

Attachments:
population_world.zip (282.4 KB)

User Avatar
Member
900 posts
Joined: Feb. 2016
Offline
you could create a integer array detail attribute for every country code, and fill it with population values for every year.

then you just call which array (country code) and item that you want to display
Edited by Andr - June 14, 2019 14:03:43
User Avatar
Member
900 posts
Joined: Feb. 2016
Offline
this feel a little bit too hacky to me and I'd like somebody to propose a more elegant and faster solution

cheers

Attachments:
csv_hack.rar (260.7 KB)

User Avatar
Member
648 posts
Joined: July 2005
Offline
see attached

Attachments:
population_world_wrangled.hipnc (144.1 KB)

  • Quick Links