topic Loading multiple csv files with the same header in QlikView

Loading multiple csv files with the same header

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I want to load multiple csv files with same column header but when I tried to load it, QV refused to respond again. The second csv file is a continuation of the first one.

Thank you all in advance.

Re: Loading multiple csv files with the same header

ogautier62 — Thu, 23 Aug 2018 21:23:58 GMT

What is your script command lines?

And what qv told you when he refused to work?

Do you load with concat as from second load

Regards

Re: Loading multiple csv files with the same header

Anonymous — Fri, 24 Aug 2018 07:19:39 GMT

Thanks for your response.

I loaded them separately. I do not know how to concatenate.

After all the lines had been loaded, the QV just stopped.

I am using two CSV files because the first one is already filled up.

Thank you in advance.

Re: Loading multiple csv files with the same header

ogautier62 — Fri, 24 Aug 2018 07:26:37 GMT

for second load and next :

concatenate (your table) load * from your csv ......

where did it stop in your script ?

it does not end the script ?

no error message ?

Re: Loading multiple csv files with the same header

Anonymous — Fri, 24 Aug 2018 07:55:57 GMT

Thank you. It stopped after fetching all the lines. I do not know may be it is because I added some script to it: vlookup, if statement,etc.

Re: Loading multiple csv files with the same header

Anonymous — Fri, 24 Aug 2018 08:04:25 GMT

It is working now. Thank you

Re: Loading multiple csv files with the same header

Anonymous — Fri, 24 Aug 2018 08:05:57 GMT

I did not concatenate. I only used the script for each file. I forgot to use it for both. I really appreciate your time and concern

Re: Loading multiple csv files with the same header

Peter_Cammaert — Fri, 24 Aug 2018 08:26:44 GMT

If your issue has been fixed, please close the discussion by either marking your own answer as "Correct", or by marking it as "Assumed Answered". That way you indicate that the situation has been resolved and doesn't require any further attention.