Load several tables incrementally, with the same name as the Excel files that are in a folder

[Fernan]

Hello, I do not have much experience, I find myself lost with this matter, 
I am trying to do a task, which I have previously looked for solutions, but they do not 
solve my needs, I will explain myself:

I receive several Excel files with a name (Filename_1, Filename_2, etc ...) 
each one determined, which are deposited in a folder.

I want to create a table for each file (Table Filename_1, Table Filename_2) 
whose names are the same as the excel file 
where the data is loaded 
(I have seen solutions but they do not create a table for each file with its name). 
These tables are related by a field.

Once I have created the structure, I want to perform incremental loads periodically.

Thank you so much in advance.

[Fernan]

Hi Frank, yes, that's the question, that's why I'm exposing it, because I don't have the knowledge to do it.
Thanks a lot

[Frank_Hartmann]

maybe I  found another way. have a look at the attached files

[Fernan]

Hello Frank, first, thank you very much for your interest.
I have been testing, with some files, but it does not work, for each excel,
it does not create a table in Qlikview,
there are files that are not loaded and I do not understand why.
I am attaching  a dataset that I have tested.
Thank you very much in advance.

[Frank_Hartmann]

one more try

[Fernan]

Hi Frank, I have been testing and it seems that now it works :).I wanted to ask you, if the table already exists, 
how could we concatenate the data to the existing table? Millions Thank you in advance ¡

[Frank_Hartmann · Accepted solution]

Maybe by adding an if then else condition in load script? see attached files.

[Fernan · Accepted solution]

Hi Frank, great :).
Thank you so much for your help and speed. 
Best regards ¡