topic Re: Splitting the Filed Name (Table's Header) into Two Separate Lines in Connectivity & Data Prep

Splitting the Filed Name (Table's Header) into Two Separate Lines

astep1990 — Tue, 28 Dec 2021 20:24:46 GMT

I have a dataset of the following structure:

Company.ID  DDR (25632) PTL (89567)
2512             89         74
9875             78         96
7892             14         73

I would like to split the header into two different lines (Transformation must be done in Script). With other words the second part of the header should or could be the first variable. How is possible to transform the dataset into the desired form (see below):

Company.ID          DDR         PTL 
     -            (25632)     (89567)
    2512             89         74
    9875             78         96
    7892             14         73

To replicate the above example in Qlik, run the code below:

LOAD * Inline [
        [Company.ID], [DDR (25632)], [PTL (89567)]
        2512,89,74
        9875,78,96
        7892,14,73
    ];

Any help or tipp would be highly appreciated!

Re: Splitting the Filed Name (Table's Header) into Two Separate Lines

Shubham_Deshmukh — Wed, 03 Apr 2019 10:38:03 GMT

Hi @astep1990 ,

Give the same name in Label and give some more spaces between DDR & (25632) and then enable Wrap Header Text option.
You can split them like this.

Re: Splitting the Filed Name (Table's Header) into Two Separate Lines

astep1990 — Wed, 03 Apr 2019 11:29:42 GMT

I am working with QlikSense. So I do not have this fancy looking menu. Can you provide the script code it generates? Thanks.

Re: Splitting the Filed Name (Table's Header) into Two Separate Lines

Shubham_Deshmukh — Wed, 03 Apr 2019 13:30:23 GMT

Hi,

You should always mention which tool you are using.

In Qliksense also you can do this, in label give some more spaces between DDR & (25632) and adjust width of column manually.