I'm attempting to import data from multiple (almost identical) .csv files using the MFI, which I have scripted as dt = Multiple File Import( ....
I have "Stack Similar Files" checked, selecting data from row 270, with the correct delimiters, but for some reason it is creating 2 separate files, one of which is nonsensical. The other is what I need. I checked and all files have the data I need in row 270.
Anyone have a problem with this?
I could get around this if I knew how to rename that second table. The second table is created with a 2 at the end of the file name, Analysis. How do I assign a name to that table that was generated that isn't the original "dt" that I assigned with the Multiple File Import.
I think I'm just rusty on JSL and could use some help. Thanks all!