Issue with the REPLACE statement ...

datanibbler — Fri, 06 Oct 2017 12:13:16 GMT

Hi,

just had a problem in the app I’m currently working on that seems to indicate there was an issue with the „REPLACE“ command that I always thought was supposed to be ignored in a regular Reload:

I have two tables in there, one very small and one very big. To make the load of the big piece optimized, I separated it (instead of directly concatenating it as it was done before) and then I concatenated it to the small piece – still not optimal, but I could not yet come up with a better way of doing it that works …

In the last piece (where I have a CONCATENATE LOAD from the large table, it seems that one field that was there was emptied of values … up to the point after I had loaded the big chunk as a separate table, the field was there and there was data in it. ó after the concatenating, the field was still there, but it was empty … it took me a while now to find out exactly where that happens, I first noticed it in the GUI – which is another app actually – because the fields were all there, but still some charts would not display anything …

I had placed the REPLACE inbetween ?table_name? - there was only the CONCATENATE of course, no separate table_name - and the LOAD - maybe that was the Problem?

Can you confirm that this can happen – and why?

Thanks a lot!

Best regards,

DataNibbler

topic Issue with the REPLACE statement ... in QlikView

Issue with the REPLACE statement ...