Grouping of columns.

[#1]

I have my columns as below

Load

A,

B,

C,

D,

E,

F,

G

From Source ;

I want to group CDE in one bucket called milestones as well as want to keep them as separate fields also.Can I do that ?

[Gysbert_Wassenaar]

I want to group CDE in one bucket called milestones as well as want to keep them as separate fields also

What do you mean? Can you post an example of the resulting table you expect?

[#3]

PFA...I want to group column C,D and E as Milestone Dates and also want to keep them as individual date columns.

Thanks much gwassenaar‌

[Gysbert_Wassenaar · Accepted solution]

Perhaps like this:

Table1:

LOAD * FROM TEXT.xlsx (ooxml, embedded labels, table is Sheet1);

Table2:

CrossTable(Milestone, Date,2)

LOAD A, B, C, D, E

FROM TEXT.xlsx (ooxml, embedded labels, table is Sheet1);

[pk2019]

Hi Pavana,

Is this what you were looking for, to combine the fields?

[Sheet1]:

LOAD

    ,

    ,

    ,

    ,

    ,

    & '|' & & '|' & as "Milestone Date",

    ,

FROM [lib://Desktop/TEST.xlsx]

(ooxml, embedded labels, table is Sheet1);

The result is something like this: