Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I need to transform a dataset and i'm stuck in the process.
Example:
ID Brand Rating Status
1 A 4 General
1 B 2 General
1 C 3 Detail
2 A 1 General
3 B 3 General
I would like to end up with this structure: Create fields according to different values of Brand(A, B, C, etc...), and populate these fields with the Rating value:
ID Status A B C
1 General 4 2
1 Detail 3
2 General 1
3 General 3
Any help would be appreciated, thank you.
Try this,
tab1:
Generic
LOAD ID, Status, Brand, Rating;
LOAD * INLINE [
ID, Brand, Rating, Status
1, A, 4, General
1, B, 2, General
1, C, 3, Detail
2, A, 1, General
3, B, 3, General
];
You will want to use the script Generic Load
-Rob
Try this,
tab1:
Generic
LOAD ID, Status, Brand, Rating;
LOAD * INLINE [
ID, Brand, Rating, Status
1, A, 4, General
1, B, 2, General
1, C, 3, Detail
2, A, 1, General
3, B, 3, General
];
Output: