Hi I load the data and create a table like the following:
But Actually I would like to add a column 'Team' which does not exist in my original dataset. And the table followed is what I want.
What should I do?
I think that Team field is created according to a logic so when you load the original table:
if(mycondition, newField, null()) as Team
Hope it helps
May be I just give a wrong table..Sorry for that.
What I would like to create is like the following:
LOAD * Inline [
If(Product='A','X1', If(Product='B','X2', If(WildMatch(Product,'C','D','E'),'X3', If(WildMatch(Product,'F','G','H','I'),'X4', 'XX' )))) as Team
DROP Table Orig;
Yes your method is work..
What's more..is there a function in QV that could merge the cells?
I suggest you that,
You Can Create Master Excel File for this & You can maintain @ 1 Place.
Which Contains Team & Product. & then you can Map That File with System Data.
Thanks..I just try the metod porvided by @Alessandro Saccone and I can work..
Retrieving data ...