topic Re: Data loading in Connectivity & Data Prep

Data loading

Billy_u — Thu, 23 Dec 2021 13:15:53 GMT

hi everyone,

I have a problem,

I 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

Re: Data loading

JordyWegman — Fri, 17 May 2019 13:54:05 GMT

Hi Billy,

How is the script generated?

Jordy

Climber

Re: Data loading

Billy_u — Fri, 17 May 2019 14:52:08 GMT

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

Re: Data loading

Billy_u — Fri, 17 May 2019 14:55:26 GMT

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

Re: Data loading

JordyWegman — Mon, 20 May 2019 08:59:10 GMT

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