Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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);
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?
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
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);
Hi Pavana,
Is this what you were looking for, to combine the fields?
[Sheet1]:
LOAD
,
FROM [lib://Desktop/TEST.xlsx]
(ooxml, embedded labels, table is Sheet1);
The result is something like this: