Try it without any number and let QlikView handle it by putting it in a different row for you:
LOAD Web_Site_Member_ID as tmp1_mbr_id,
SubField(Products_Used, '|') as tmp1_product
And I guess if you want it all in different columns, manipulate the script after you run the above. If you can provide some sample data, we might be able to give a better response.
Wow, I was really over engineering a simple solution! I had as my next step a FOR/NEXT loop that took the results of my SUBFIELD step and created a new row for each column so all values were in the same column on a separate row. But now I see that Qlik Sense will do that automatically if I just leave off the column number on the SUBFIELD statement. Much cleaner! Thanks for the tip!