Dynamic Table linked with Key Field and connected to Excel file フォローする
Target Example attached as pictures.
I am trying to exploit the new dynamic table object in a case where we connect to one excel file which in one sheet has a list of labels to be printed and corresponding data for header fields and another sheet has a list of lines (with key to Box number from header) on what should be listed in a dynamic table on each label.
I.e. based on below and attached example, target is to let the Designer populate 3 labels (dynamic amount depending on lines in header sheet)
- with fields working as header information (header1 and header2) - easy to get to work independently with datasource on fields from excel
- with a table on same label only with the lines that has box = box on header list - I can't get the table to filter correctly, either with join as data source I get populated to many fields or if I only import as dynamic table I can get it to make one label with unique values per header line.
Any ideas on getting on the right track here?