Hello mighty pools of wisdom 😉
I am stuck...
For each client we upload 4 images to a server.
Each client has a clientcode field.
All files on the server are labeled: [clientcode]_Product_1.png
(Example: S56H3M2_Product_1.png .. S56H3M2_Product_4.png)
What I am trying to do is: with only this one specific client [clientcode] selected, now on a 'reload' download the 4 images AS Product1 .. Product4.
If I reload without one specific client selected: memory can be cleared.
Something like:
LOAD
w3.example.com/images/[clientcode]_Product_1.png AS Product1,
w3.example.com/images/[clientcode]_Product_2.png AS Product2,
w3.example.com/images/[clientcode]_Product_3.png AS Product3,
w3.example.com/images/[clientcode]_Product_4.png AS Product4;
I will then display the product image as text object (with image representation) into a report.
Anyone with an idea? Thank you so much in advance.
Alex
