I need to normalise a table and have read a number of the communities posts but they are not quite the same as my data table.
I know that I must do multiple steps but I am stuck after the initial cross table script. I lose dimensions and then cannot get to the next steps.
Once I have the fields loaded I then need to do some transformations using if statements that I have already compiled and loop through the other files in the directory to consume these as well.
Attached is my data file, how it should look (example from and to) and my attempt at the Load data manually script in the qvf file.
