Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Script error

Hi guys!

 

I'm trying to use a new table on my app, but during the execution of the task to load the data, I'm receiving the following error:

erro_log.png

Someone here knows what this error means? "-129 = "

 

Thanks for the help!

Labels (4)
1 Solution

Accepted Solutions
Creator II
Creator II


If you are going to join them through the address, what you would have to do minimum have the same field name in the 2 tables, notice that when you add the sentence "AS", in both tables you are adding different names, in a "Client emissor .... "and in the other" Client fiscal domicile ... ".

use the same name in both tables so that the JOIN is done correctly.

Regards!!!!

View solution in original post

4 Replies
Creator II
Creator II

Hi how are you?

Could you tell us how are you relating the tables?

I see that you have a LEFT JOIN statement but you do not clarify which table you are doing the LEFT, it usually points to the last added table (the table above)
I recommend adding left join (your_table), now I also see that you do not have fields in common in those 2 tables that you show us, this will make you have as a result a Cartesian. I ask you if you can review that.

Regards!!!!

Contributor III
Contributor III

Marcos, I'm good. Thanks!

My commom field is the [TXJCD] and the concatenated one ([ZE_CHARUF] & ' ' & [ZE_TXJCD].

I cant match fields with a concatenation?

Thanks!
Creator II
Creator II


If you are going to join them through the address, what you would have to do minimum have the same field name in the 2 tables, notice that when you add the sentence "AS", in both tables you are adding different names, in a "Client emissor .... "and in the other" Client fiscal domicile ... ".

use the same name in both tables so that the JOIN is done correctly.

Regards!!!!

View solution in original post

Contributor III
Contributor III

Thank you so much, Marcos!
Works perfectly!