ApplyMap to same file name record does not work for load *
Hi,
I have about 13 files to load. In each file, I have 2 tabs to load. For each row of transaction, I want to insert the first 3 char of the file name as a new column and use applymap to get the full name to replace these three char.
I have used Load directorypath/*.xls to load in all the 13 files, and then used apply map for this new column(value derived from first 3 char of the file name).
However, when the script is run, I realised that the file name is returned as '-'. I have trimmed the spaces and used UPPER before calling applymap but to no avail.
Can anyone help? I have searched the community and saw that this maybe due to calling of multiple files using the wildcard symbol, resulting that the filename is not derived.
I kept the FIELD code and the codes have been read in. But apparently the applymap function didnt seem to be working and I am not sure yet why it's not working. I hovered over the field in the table viewer but I am not sure what I am supposed to be looking out for.
The strange thing that it's showing up as a dash sign. In my mapping code, I asked to be returned unknow+ unmapped code. But I didnt get anything. Hence I am suspecting that the mapping table function is somehow not working as it should be.
Thanks to everyone's help. I took a look at the log when the script was running and realised that indeed, the mapping table was not loaded.
Upon closer examination, I spotted the bug. There was a lack of semi-colon on the last line in the main tab. As such, the first mapping table was not loaded.
And crosstable is not affected by the sequence of applymap and Applymap does run in a loop when I use the wildcard sign.
