https://community.qlik.com/t5/Connectivity-Data-Prep/Accessing-records-from-standalone-table/m-p/1892830#M10221 <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Übersetzung"><SPAN class="Y2IQFc">Hi there, I'll try to explain what I want to achieve. I have tables with the following structure: T1: Order number|Number of racks A1|3 A2|4 A3|1 T2: Shelf|Number of free parking spaces R1|3 R2|2 R3|5 R4|8 The tables are not related because there are no relationships between them. I would now like to have an additional field (shelf suggestions) in T1, which should contain the shelves that can hold the number of racks: T1: Order number|Number of racks|shelf suggestions A1|3|R1 R3 R4 A2|4|R3 R4 A3|1|R1 R2 R3 R4 Thank you for any food for thought.</SPAN></PRE> Tue, 15 Feb 2022 05:23:59 GMT MarcoFischer 2022-02-15T05:23:59Z https://community.qlik.com/t5/Connectivity-Data-Prep/Accessing-records-from-standalone-table/m-p/1892830#M10221 <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Übersetzung"><SPAN class="Y2IQFc">Hi there, I'll try to explain what I want to achieve. I have tables with the following structure: T1: Order number|Number of racks A1|3 A2|4 A3|1 T2: Shelf|Number of free parking spaces R1|3 R2|2 R3|5 R4|8 The tables are not related because there are no relationships between them. I would now like to have an additional field (shelf suggestions) in T1, which should contain the shelves that can hold the number of racks: T1: Order number|Number of racks|shelf suggestions A1|3|R1 R3 R4 A2|4|R3 R4 A3|1|R1 R2 R3 R4 Thank you for any food for thought.</SPAN></PRE> Tue, 15 Feb 2022 05:23:59 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Accessing-records-from-standalone-table/m-p/1892830#M10221 MarcoFischer 2022-02-15T05:23:59Z https://community.qlik.com/t5/Connectivity-Data-Prep/Accessing-records-from-standalone-table/m-p/1892902#M10223 <P><A href="https://community.qlik.com/t5/Deutsche-User-Group/Zugriff-auf-Datens%C3%A4tze-aus-eigenst%C3%A4ndiger-Tabelle/td-p/1892724" target="_blank">Zugriff auf Datensätze aus eigenständiger Tabelle - Qlik Community - 1892724</A></P> Tue, 15 Feb 2022 08:25:53 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Accessing-records-from-standalone-table/m-p/1892902#M10223 marcus_sommer 2022-02-15T08:25:53Z