Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I have created a little inline table with dates and typs. I know that this example make not really sense but I have a question about this. So what I am trying to do is the following...
This is the Inline table:
table:
LOAD * INLINE [
Date, Typ
1.1.2015, A
2.1.2015, A
1.1.2015, B
2.1.2015, B
];
And now I want to transform the table into this table...
Typ / Key
A / 1.1.2015_2.1.2015_A
B / 1.1.2015_2.1.2015_B
How I can do it?
Maybe like
table:
LOAD * INLINE [
Date, Typ
1.1.2015, A
2.1.2015, A
1.1.2015, B
2.1.2015, B
];
LOAD Typ, Concat(Date,'_') &'_'&Typ as Key
Resident table
GROUP BY Typ;
Or if you want to show extrema:
table:
LOAD * INLINE [
Date, Typ
1.1.2015, A
2.1.2015, A
1.1.2015, B
2.1.2015, B
];
LOAD Typ, Date(Min(Date),'D.M.YYYY') &'_'&Date(Max(Date),'D.M.YYYY') &'_'&Typ as Key
Resident table
GROUP BY Typ;
May be this:
Table:
LOAD * INLINE [
Date, Typ
1.1.2015, A
2.1.2015, A
1.1.2015, B
2.1.2015, B
];
NewTable:
NoConcatenate
LOAD Typ & ' / ' & Concat(Date, '_', RecNo()) & '_' & Typ as Date
Resident Table
Group By Typ;
DROP Table Table;