Re: Re: Generic load - does not create the new table
Hello Tanja, I tested a simulation of the LEFT JOIN method and perhaps a component that was missing was a WHERE clause that drops all join entries where the target field is null. (i.e. WHERE Len(Trim([LIBELLEHIERARCHIE$(I)])) > 0 )
You can see my simulation and results in the image below:
When I don't use the aforementioned WHERE clause, my example creates 64 rows of data (with plenty of null pockets), however when the WHERE clause is activated, it drops all rows where the target field is blank and the load produces one single "unified" row, kind of "accordion" collapsing the data spread out over the original table.