Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Can someone please help me in achieving the format table view?
Actual Table:
Name | color | Category |
Apple | Red | Fruit |
Apple | green | Fruit |
Grape | white | Fruit |
Grape | black | Fruit |
Onion | white | veggi |
Onion | Red | veggi |
Pepper | Red | Veggi |
Pepper | green | veggi |
Expected / Result:
Name | color |
Fruit | |
Apple | Red |
Apple | green |
Grape | white |
Grape | black |
Veggi | |
Onion | white |
Onion | Red |
Pepper | Red |
Pepper | green |
Try this
For each _cat in FieldValueList ('Category')
Load '$(_cat)' as Name,
NULL () as color
Autogenerate (1);
CONCATENATE LOAD Name, color from Source
WHERE Category = '$(_cat)';
Next