Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm at my wits's end with this but I bet the answer is simple! Hopefully one of you clever lot can help me...
Here is my script:
User:
LOAD User,
Name,
Colour
FROM
(ooxml, embedded labels, table is Users);
Films:
LOAD User,
Film
FROM
(ooxml, embedded labels, table is Films);
There are 5 records in the User table, and 8 in Films. User #5 doesn't have any records in Films. Therefore, I want an entry in a Films listbox with <None> that is selectable. I have tried using IsNull and LEN in the script to no avail. Help!
I've attached the qvw...
Thank you,
Jason
Hi Jason,
see the modified example (script part) and try to use MAPPING.
Good luck!
Rainer
Hi Jason,
see the modified example (script part) and try to use MAPPING.
Good luck!
Rainer
Thank you Rainer - that worked perfectly!
Typically though, after spending DAYS on this I found another solution just after posting my question! As I have many more tables to join, all of which might have missing values related to the mater User table I think this second way will be a bit tidier. See attached example.
Thanks again,
Jason