This howto shows you how to load an HTML table in a SQL Table.
Because the HTML resource is a file resource, it can be used as any source in any type of transfer.
Example with the upsert operation and the 10 languages code
tabul data upsert \
https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes \
@sqlite
Transfer results
input target latency record_count error_code error_message
--------------------------------------------------- ------------------------------ ------- ------------ ---------- -------------
[email protected]\wiki list_of_iso_639_1_codes@sqlite 0.82s 184
tabul data head list_of_iso_639_1_codes@sqlite
The first 10 rows of the data resource (list_of_iso_639_1_codes@sqlite):
ISO Language Names Set 1 Set 2 Set 3 Scope Type Endonym(s) Other Name(s) [note 1] Notes
------------------ ----- ----- -------- ------------- ------------- ------------------------------- ---------------------- ------------------------------------
Abkhazian ab abk abk Individual Living Аҧсуа; Apsua; აფსუა Abkhaz
Afar aa aar aar Individual Living Qafar af
Afrikaans af afr afr Individual Living Afrikaans
Akan ak aka aka + 2 Macrolanguage Living Ákán Twi is tw/twi, Fanti is fat
Albanian sq sqi alb sqi + 4 Macrolanguage Living Shqip called "Albanian Phylozone" in 639-6
Amharic am amh amh Individual Living አማርኛ (Amarəñña)
Arabic ar ara ara + 28 Macrolanguage Living اَلْعَرَبِيَّةُ (al-ʿarabiyyah) Standard Arabic is arb
Aragonese an arg arg Individual Living Aragonés
Armenian hy hye arm hye Individual Living Հայերեն (Hayeren)