Error from resident to load a new table

[Xolink1389]

i try to load this table from a google sheet, but it say that OperacionArgl not found when actually exist 

i cant load diferents residents?

[MeehyeOh]

Hi, @Xolink1389 

I think you need check for load until before of the JusteIntercia2 table load syntax and verify that the OperationArgl12 table exists through the Data Model Viewer.

For some reason, the OperationArgl12 table may have been concatenated to another table.

please reply!

[Xolink1389]

the load from the tables exist 

but i thinking that because both use the same names from the field they are concatenaded and in the model view only exist one for the same reason i guess...

there is another to load the tables without concatenate? i mean both are google sheet, its another way to load them?

[MeehyeOh · Accepted solution]

Hi, @Xolink1389 

As you can see, the [OperationArgl12] table is concatenated in the [OperationArgl] table.

That's why the error occurred because the load syntax says "Resident OperationArgl12".

There's not exists [OperationArgl12] table.

I think if you change the phrase to "Resident Operation Argl", there will be no error.

Q : there is another to load the tables without concatenate? 

A : By default, Qlik Sense automatically concatenates the table if the fields that make up the table are the same.
If you want to load two tables without concatenate,
1) you can change the field name.
2) import "Noconcatenate" syntax in pront of "Load". But In your case, If you use "Noconcatenate" syntax then qlik will make Synthetic keys between "OperationArgl"table to "OperationArgl12"table.

please reply! thanks!

[Xolink1389]

i just rename the fields as you say, thanks