Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I got two text fields to be concatenated in the following way in a new field: "Esito [Att]"-"Sottoesito" [Att]".
"Esito [Att]" has 2 values:
- OK
- KO
"Sottoesito [Att]" has 2 values:
- BLOCCANTE
- NON BLOCCANTE
I need to create a new field where I will have:
- OK If "Esito [Att]"=OK
- KON If "Esito [Att]"=KO AND "Sottoesito [Att]"=NON BLOCCANTE
- KOB If "Esito [Att]"=KO AND "Sottoesito [Att]"=BLOCCANTE
Thanks in advance
Bruno
I think you mostly have done it yourself:
LOAD
...
if("Esito [Att]" = 'OK', 'OK'
, if("Sottoesito [Att]" = 'NON BLOCCANTE', 'KON','KOB')) as NEWFIELD,
....
FROM ...;
Hope this helps,
Stefan
Hi,
You have to write code some thing like below in load script to concat two field.
Load
..
..
Field1 & ' - ' & Flied2 as Concat field
From Data
Rgds
Anand
I think you mostly have done it yourself:
LOAD
...
if("Esito [Att]" = 'OK', 'OK'
, if("Sottoesito [Att]" = 'NON BLOCCANTE', 'KON','KOB')) as NEWFIELD,
....
FROM ...;
Hope this helps,
Stefan
Hi,
Or you can do like
Load
....
....
If( "Esito [Att]" = OK) as OK,
If( "Esito [Att]" = KO AND "Sottoesito [Att]" = NON BLOCCANTE ) as KON,
If( "Esito [Att]" = KO AND "Sottoesito [Att]" = BLOCCANTE ) as KOB
....
From Data
Rgds
Anand
And how can i put all togheter in a New Field?
Thanks
Hm,
with my above posting you should have one NEWFIELD with three possible values (OK, KON, KOB)...
Stefan
Hi,
You can use
Load
....
If( "Esito [Att]" = OK, 'OK'),
If( "Esito [Att]" = KO AND "Sottoesito [Att]" = NON BLOCCANTE, 'KON'),
If( "Esito [Att]" = KO AND "Sottoesito [Att]" = BLOCCANTE, 'KOB' ))) as NewField
....
From Data
Rgds
Anand