Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I load my information I have to store everything in the same table “HomeDepot_1” but I don’t understand why a table loads it to “HomeDepot_1-1” this started to happen without any reason.
It is likely because you are loading using
LOAD *
And the files have a different number of columns.
-Rob
So what can I do to make it not happen?
Use the Concatenate prefix to force load into a single table. But first you'll have to create a table to name in the Concatenate().
HomeDepot:
LOAD 0 as DummyField AutoGenerate 0;
Concatenate (HomeDepot)
LOAD *
From lib://Exceles/blah blah/*.xlsx;
Drop Field DummyField;
-Rob