Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Billy_u
Creator
Creator

Data loading

hi everyone, 

I have a problem,

Cattura.JPGI need to update data from an excel source, and I can't find a field, how can I solve it, the script is all automatic

Labels (2)
4 Replies
JordyWegman
Partner
Partner

Hi Billy,

How is the script generated?

Jordy

Climber

Work smarter, not harder
Billy_u
Creator
Creator
Author

if i comment this:

 

Where len(trim(città))>0;

 

the code runs, but and  found another field, because i think is renamed in the source with another language, but if i change with

 

Where len(trim(city))>0;

 

it's the same not found city.

 

in the source i have two field keys, in some are in one language in another in another language,

the language total is two.

 

 

i hope managed to explain

 

 

 

 

 

 

 

 

 

 

 

 

 

Billy_u
Creator
Creator
Author

how can explain how generate the cose?

is a series of variables and cycles

--------------------------------------------------------------------------------------------------------------------------

if i comment the script this:

 

//Where len(trim(città))>0;

 

the code runs, but and  found another field, because i think is renamed in the source with another language, but if i change with

 

Where len(trim(city))>0;

 

it's the same not found city.

 

in the source i have two field keys, in some are in one language in another in another language,

the language total is two.

 

 

i hope managed to explain

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

JordyWegman
Partner
Partner

Hi Billy,

The approach you should take is that you need to create one table with all the information.

From the two sources, pick one that is going to be your table. In the other table, you should rename all your fields and concatenate this information.

Small example:

Table1:
Load
   City
From [YourSource](qvd);

Concatenate(Table1):
Load
   Città as City
From [YourSource](qvd); 

Jordy

Climber

 

Work smarter, not harder