semantic_fields

Src Category (auto)

KFTFIELD-00e7042f21f648140a12d40bCompare this game →

Original value

""

Original fields 16

semantic_field_id: KFTFIELD-00e7042f21f648140a12d40b
semantic_record_id: KFTREC-5e2e12f0a044e601579bada7
manifest_id: SRC-11b39259f9dae3b7
source_row_atom_id: ATOM-7b019420d56605457988ce20
sheet_name: I1. Pros & Cons
source_row_number: 489
cell_ref: D489
header: Src Category (auto)
normalized_field_role: CLASSIFICATION
common_field: record.category
value_kind: FORMULA
raw_value: ""
resolved_text: ""
formula_json: {"attributes": {}, "text": "IF($A489=\"S1\",IFERROR(INDEX(tbl_S1_ConfigCatalog[Category], MATCH($B489, tbl_S1_ConfigCatalog[Config Item],0)),\"\"),IF($A489=\"S2\",IFERROR(INDEX(tbl_S2_GrowthContentCatalog[Category], MATCH($B489, tbl_S2_GrowthContentCatalog[Content Name],0)),\"\"),IF($A489=\"S3\",IFERROR(INDEX(tbl_S3_CompetitionContentCatalog[Category], MATCH($B489, tbl_S3_CompetitionContentCatalog[Content Name],0)),\"\"),IF($A489=\"S4\",IFERROR(INDEX(tbl_S4_CoopContentCatalog[Category], MATCH($B489, tbl_S4_CoopContentCatalog[Content Name],0)),\"\"),IF($A489=\"S5\",\"\",IF($A489=\"S6\",IFERROR(INDEX(tbl_S6_GrowthSystemCatalog[Growth Target], MATCH($B489, tbl_S6_GrowthSystemCatalog[System Name],0)),\"\"),IF($A489=\"S7\",IFERROR(INDEX(tbl_S7_EconomyItemCatalog[Major Category], MATCH($B489, tbl_S7_EconomyItemCatalog[Item Name],0)),\"\"),IF($A489=\"S8\",IFERROR(INDEX(tbl_S8_GachaCatalog[Gacha Category*], MATCH($B489, tbl_S8_GachaCatalog[Gacha/Banner Name],0)),\"\"),IF($A489=\"S9\",IFERROR(INDEX(tbl_S9_ShopCatalog[Payment], MATCH($B489, tbl_S9_ShopCatalog[Shop/Offer],0)),\"\"),IF($A489=\"S10\",IFERROR(INDEX(tbl_S10_EventCatalog[Category], MATCH($B489, tbl_S10_EventCatalog[Event Name],0)),\"\"),\"\"))))))))))"}
source_span_json: {"cellRange":"C489:O489","cellRef":"D489","kind":"xlsx_cell_range","rowNumber":489,"sheet":"I1. Pros & Cons","sourceSha256":"a77e9b9da6914e35e19dc05e2557df72c2aa520748b89930b188c0e6f90d19bd","workbookPart":"xl/worksheets/sheet18.xml"}
content_hash: ff04dfc65115e2c24ed0edde3ad519da7daa73cad33cf5b8bb7d074b0c39caef