data on one line

[Luke_Killer_IT]

Hi

I would like to see the data from L and H on one line. Is it possible to do that?

I load L and H in the script

[Taoufiq_Zarra]

@Luke_Killer_IT  if I understood correctly

in your new dimension :

if(len(trim(L))=0,H,L)

like :

[yassinemhadhbi]

Hi,

Can you share your script please

[Luke_Killer_IT]

BS_Zuord:
Load
Owning_Obj as S_Artikel_obj,
if(Merkmal='23',Auspr) as L,
if(Merkmal='24',Auspr) as H
FROM
[$(ImportPfadExport)$(Modul)BS_Zuord.qvd](qvd) where SMLeiste='AB-Param' and (Merkmal='23'or Merkmal='24');

[Luke_Killer_IT]

that's more what I meant

[yassinemhadhbi]

it would be better if you shared a sample of your application

[Taoufiq_Zarra · Accepted solution]

@Luke_Killer_IT  you can try something like

BS_Zuord:

Load
Owning_Obj as S_Artikel_obj,
if(Merkmal='23',Auspr) as L,
if(Merkmal='24',Auspr) as H
FROM
[$(ImportPfadExport)$(Modul)BS_Zuord.qvd](qvd) where SMLeiste='AB-Param' and (Merkmal='23'or Merkmal='24');

final:
noconcatenate
load Teil, TeilArt,Bezeichnung,concat(L,'') as L,concat(H,'') as H  resident BS_Zuord group by Teil, TeilArt,Bezeichnung;

drop table BS_Zuord;

[Taoufiq_Zarra]

@Luke_Killer_IT  or yous your script

BS_Zuord:

Load
Owning_Obj as S_Artikel_obj,
if(Merkmal='23',Auspr) as L,
if(Merkmal='24',Auspr) as H
FROM
[$(ImportPfadExport)$(Modul)BS_Zuord.qvd](qvd) where SMLeiste='AB-Param' and (Merkmal='23'or Merkmal='24');

and in UI use chart:

dimension: Teil, TeilArt,Bezeichnung,..

meausre : concat(H,'') and concat(L,'')

[Luke_Killer_IT]

@Taoufiq_Zarra  @yassinemhadhbi 

teile and teileart uses a different table S_artikel

[Taoufiq_Zarra]

@Luke_Killer_IT  the second solution will work for you