Loading data

[Luis_Gueerero13]

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.

[rwunderlich]

It is likely because you are loading using 

LOAD *

And the files have a different number of columns. 

-Rob

[Luis_Gueerero13]

So what can I do to make it not happen?

[rwunderlich]

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