VLOOKUP in Mapinfo
121 views
Skip to first unread message
AL
Jun 15, 2017, 1:15:36 AM6/15/17
to MapInfo-L
Dear all,
I have 2 tables with the same column structures. Let say:
1. Table POI with 1000 rows
2. Table DIGITAL with 5 rows
These 5 rows in DIGITAL is actually taken from POI, but for both tables I add one more column is like "Farm". The value of farm in POI still blank, while in DIGITAL is "Yes".
I want to vlookup POI to DIGITAL so that 5 rows in POI will be valued "Yes" and the others 995 is "No"
Your advice will be greatly appreciated.
Regards,
Aldindha Octa Airlangga
I have 2 tables with the same column structures. Let say:
1. Table POI with 1000 rows
2. Table DIGITAL with 5 rows
These 5 rows in DIGITAL is actually taken from POI, but for both tables I add one more column is like "Farm". The value of farm in POI still blank, while in DIGITAL is "Yes".
I want to vlookup POI to DIGITAL so that 5 rows in POI will be valued "Yes" and the others 995 is "No"
Your advice will be greatly appreciated.
Regards,
Aldindha Octa Airlangga
Le Dzung
Jun 15, 2017, 4:10:55 AM6/15/17
to MapInfo-L
you can use Menu Table/Update column/ join table to link common column
Vào 12:15:36 UTC+7 Thứ Năm, ngày 15 tháng 6 năm 2017, AL đã viết:
Vào 12:15:36 UTC+7 Thứ Năm, ngày 15 tháng 6 năm 2017, AL đã viết:
Reply all
Reply to author
Forward
0 new messages