topic Re: Concatenate tow fields or more.. in QlikView

Concatenate tow fields or more..

Wed, 19 Nov 2014 11:22:08 GMT

hello,
I would create a field from other fields. I tried to surround the fields with (*), puisavec "but it does not work !!!

here is my script:
ICP_DATA:
Laod *;
SQL select ....

[...]

STORE ICP_DATA Into $ (vSaveQVD) BILLING.QVD (qvd);

NoConcatenate

load NumSum(Frais1, Frais2) as 'Total Frais Prod',

"Code Tiers"&"Code Article" as 'Compte Clef',

Concat(';',Code Sous-Fam. Article,';',C2 Tiers,';') as 'Clef STARR',

left("Code Tiers",3) as 'Filtre Compte Client',

Concat(';',Filtre Compte Client,Clef STARR) as 'Clef STARR ICP'

Resident ICP_DATA;

The fields ( Frais1, Frais2, Code Sous-Fam. Article,C2 Tiers) are created in the SQL SELECT query.

How to solve this problem?

Regards

Re: Concatenate tow fields or more..

CELAMBARASAN — Wed, 19 Nov 2014 11:26:37 GMT

In Qlikview Concatenation operator is '&', try like this

';'&[Code Sous-Fam. Article] & ';' & [C2 Tiers] & ';' AS [Clef STARR]

Re: Concatenate tow fields or more..

tresB — Wed, 19 Nov 2014 11:44:35 GMT

If you have field names with space in between, you have to enclose them within [] or "". Try like:

Concat(';',[Filtre Compte Client],[Clef STARR]) as 'Clef STARR ICP'

Re: Concatenate tow fields or more..

Wed, 19 Nov 2014 13:50:58 GMT

Hi,

I would thank you for you help,

I changed ('') by [], but I still have the problem.
but I have the same problem
Found field - <Filtre Compte Client>

NoConcatenate

Load NumSum(Frais1, Frais2) as 'Total Frais Prod',

"Code Tiers" & "Code Article" as 'Compte Clef',

';' & "Code Sous-Fam. Article" & ';' & "C2 Tiers" & ';' as 'Clef STARR',

left("Code Tiers",3) as [Filtre Compte Client],

';' & "Filtre Compte Client" & "Clef STARR" as 'Clef STARR ICP'

Resident ICP_DATA;

is that I should not create a second load just to create 'Clef STARR ICP ??

because [Filtre Compte Client] does not exist in ICP_DATA

Regards

Re: Concatenate tow fields or more..

PradeepReddy — Wed, 19 Nov 2014 14:09:29 GMT

You can read only the existing fields from the resident table...

If u want to use the filed [Filtre Compte Client] in your load statement, create the filed [Filtre Compte Client] while loading the data from Database itself.