Spreadsheet: 808619d1670535704-get-multiples-values-in-table-via-expressions-truncated-in-words-get_value_table_filter_label
Sheet: Feuil1

 |  | expected result
# | configuration | suffix |  | valueA_data_suffix1 | [NAME] | valueB1_data_suffix1 | valueB2_data_suffix1 | valueB_data_suffix1 | valueC_data_suffix1 | valueC_data_suffix2 | valueD_data_suffix1 | valueE_data_suffix1 | valueE1_data_suffix2 | valueE2_data_suffix2 | valueE_data_suffix2 | valueE_data_select1 | valueF_data_suffix1 | valueG_data_select1 | valueG_data_suffix3 | valueH_data_suffix1 | valueI_data_suffix1 | [NAME]
1 |  |  |  | JLZBR | RHFRP | AZGXO | AXCRY | ODXDP | NNIDT | ETEQL | CYTWX | ZJJGZ | WKGVW | MZLVX | IWAQP | YLOEE | OXUMH | VUNZM | IAGQZ | YLOEE | NIRMW | [NAME]
2 | valueC_configuration | UYBKS,JGUYV |  | ETHBW | DWTUF | [NAME] | NAMVY | QYOON | UYBKS | JGUYV | UMAPC | MJCQM | UGPED | ZBYCV | QJNAH | GQLUC | FOONU | EAWSK | AIHZT | GQLUC | QBYXL | VMRTX
3 |  |  |  | ZYDNM | GBJRY | OOSSV | [NAME] | ZBZYB | MFOUJ | BDBHN | IVRXF | QFCML | WUUYR | LEFEB | USCVL | BSAKC | DAMSL | DUDNQ | DQNAU | BSAKC | MVIVQ | FYNNX
4 | valueE_configuration | IFLZZ-GGOTZ |  | UUIRQ | QWUJL | QRJWL | YDHYS | ZIBKH | [NAME] | GIDGJ | SOPQC | IFLZZ | VELDM | OIBXB | GGOTZ | XXTSY | MBUFK | LDNYW | HXAWO | XXTSY | FRQKM | FZKPF
5 |  |  |  | KRRLI | TTVHP | LZFHP | MADVK | KARQG | JMNQZ | GKOSS | BAWPA | UQFAY | [NAME] | ZWOZH | QFSSM | JKWOF | QYRKX | HJRLK | FHCJZ | JKWOF | KIXMK | OLWBE
6 | valueG_configuration | QCUQB |  | HUELL | ZCNOW | ZZSOF | BOZTQ | CHQBI | GTAKG | WBKRY | UWHXH | QKMHX | NJVYQ | MJOKA | [NAME] | RGCIA | BZNXM | ATCIH | QCUQB | RGCIA | KTJWT | FYEIX
7 |  |  |  | SAZUT | CDJQZ | ZJDMT | LJMYV | QLNAO | SCRYI | PIMPX | GVITQ | PGYIP | LBAXT | HTHQW | CEFCU | EBCLQ | GFBXH | FNNUE | SJLFA | EBCLQ | DHDYK | ZRQQQ
8 | valueA_configuration,valueB1_configuration | GFMLV,ZBWUK-GLPGU |  | GFMLV | [NAME] | GLPGU | TIWOH | LVLXO | JWPMX | KDAFI | SBSVJ | YSIUW | THGNB | OEXON | RQPKW | EOOQK | JTXNI | BEBDY | OUWRM | EOOQK | OYLZM | AXJWA
9 |  |  |  | QXFIW | [NAME] | LOHXA | JVLKZ | HYVAP | AJEQT | EHPDA | EYQGU | SJHPM | XKBTC | GHGWI | [NAME] | QNSUY | [NAME] | EFMJQ | BHLKW | QNSUY | PMCTL | KMLNZ
 |  |  |  |  |  | shall locate first within E2:W2, all labels which contain:
 |  |  |  |  |  | - condition1
 |  |  |  |  |  | - on the left of the label, before the first "_", the different possible values wich exist before "_configuration" (valueA, valueB , valueB2 etc.), for each row, in B3:B11
 |  |  |  |  |  | - example: "valueC_configuration" in B3:B11, we would look after "valueC" types, so our selected labels in this first step will be: "valueC_data_suffix1" and "valueC_data_suffix2" (two matches)
 |  |  |  |  |  | - notice: in B3:B11, there could be a single configuration value, or multiple, comma-separated, in which case we shall locate all corresponding labels in E2:W2
 |  |  |  |  |  | - example: "valueA_configuration,valueB1_configuration" in B3:B11, here we look for "valueA" and "valueB1" types, this would return "valueA_data_suffix1", "valueA_data_suffix2" and "valueB1_data_suffix1" (three matches)
 |  |  |  |  |  | - condition2
 |  |  |  |  |  | - on the right of the label, after the last "_", any labels with "suffix" as a root ([NAME], [NAME], etc.)
 |  |  |  |  |  | - it means that any root which is not "suffix" shall be excluded
 |  |  |  |  |  | - example: "valueE_configuration" in B3:B11, here we look for "valueE" on the left (condition1) and "suffix" on the right ([NAME]), this would return "valueE_data_suffix1", "valueE_data_suffix2" (two matches), however "valueE_data_select1" would be excluded because of condition2
 |  |  |  |  |  | then shall return the value(s) of the arrays of the selected labels, for the corresponding row:
 |  |  |  |  |  | - if there is a single array (single label), then it has to be a single result
 |  |  |  |  |  | - example, "valueG_configuration" woud lead to a single label "valueG_data_suffix3", this would return a single value, QCUQB
 |  |  |  |  |  | - if there are multiple arrays, the results is as follow:
 |  |  |  |  |  | -- if there are multiple suffixes for the same configuration, then we separate the results with a comma
 |  |  |  |  |  | -- example, "valueC_configuration" (single configuration) woud return 2 suffixes, which we display as follow: UYBKS,JGUYV (separator: comma)
 |  |  |  |  |  | -- if there are multiple configurations, then we separate such results with an hyphen
 |  |  |  |  |  | -- example, "valueA_configuration,valueB1_configuration" (two configurations) woud lead to 1 suffix for the configuration1, and 2 suffixes for the configuration 2, which we display as follow: GFMLV,ZBWUK-GLPGU (separator: comma, then hyphen)