Hi there!
I have an issue.
I have the following data:
ST OBJ CITY
R-PC-023 R-ST-MISUR GOSSOLENGO
R-PC-023 R-ST-ABC
R-PC-023 R-ST-BCDE
R-PC-023 R-ST-POMP
R-PC-023 R-ST-SCR GOSSOLENGO
My goal is to compile the “City” column when it is empty.
The ST is the “key” for extract the “city”.
Thank you in advance
It’s unclear to me what exactly it is that you’re trying to accomplish. What do you mean by “compile” ?
Do you have an example of your desired output?
1 Like
Issue has been solved as following:
- I extraced all Comune for each ST
- In my main “file”, for each ST i added the Comune from extraction at point 1
- Dropped the Comune column of my main file because i appended the new one of point 2
1 Like
system
Closed
4
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.