I have created a sample file
kindly check the script editor
I have commented a small bit of code... uncomment if you require the tables separately
for creating a blank table you can use the inline table syntax which is present in the code.
Hope this helps...
Mapping Table.qvw 157.8 K
Thanks for the help,
I can't open the attached file. It says that I would have to change my settings to view it, since I'm using personal edition, and that I wouldn't be able to see any of my own documents again if I choose to change those settings. Perhaps a .txt file with the code...? or just copy paste. Though I've solved it, I'd be interested in still seeing how you went about it, and perhaps there's something I could learn from it.
Anyway, if anyone has this problem I found an awesome solution after a ton of searching. Qlikview has a built-in funtion called substring(), which made the task super simple. I used it like this:
SQL SELECT master_file, pin_list, prefix_list
master_file, SubField(pin_list, ';') as PIN
master_file, SubField(prefix_list, ';') as prefix