Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data with several dates and want to show like below.
Sample input data and output given below
Input :
PN | CN | Date | Value |
1 | A | 4/9/2017 | 1 |
1 | A | 5/9/2017 |
|
1 | B | 5/9/2017 |
|
1 | B | 6/9/2017 |
|
1 | B | 7/9/2017 |
|
2 | A | 4/9/2017 | 1 |
2 | B | 3/9/2017 |
|
2 | B | 5/9/2017 |
|
2 | C | 4/9/2017 | 1 |
2 | C | 5/9/2017 |
|
Should be like :
just Pivot the Date field in a Pivot Table or Look at Generic Load
Hi,
Try like this
Data:
LOAD
*,
'Date' & AutoNumber(YourDateFieldName) AS DateNumber
FROM DataSource;
Now use Pivot table, drag DateNumber and your date field to top then you can get the similar layout.
Regards,
Jagan.