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
carrot
mango
grapes
orange];
by using pick and match I want output like this ;
field name category
potato vegetable
radius vegetable
beans 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?