Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an output like this Given below :
load * inline [
field name
potato
radius
beans
potato
carrot
mango
grapes
orange];
by using pick and match I want output like this ;
field name category
potato vegetable
radius vegetable
beans vegetable
potato vegetable
carrot vegetable
mango fruit
grapes fruit
orange fruit
here need to separate the groups by using pick and match
please anybody help
Where is the information stored that potato is a vegetable and mango a fruit? Looks like a case of ApplyMap() to me.
mapType:
MAPPING LOAD * INLINE [
item, category
potato, vegetable
radius, vegetable
mango, fruit
];
Basket:
LOAD
*,
ApplyMap('mapType', item) AS category;
LOAD * INLINE [
item
potato
radius
mango
];
Result:
What are you trying to achieve in the end?