Match function

[nareshthavidishetty]

Hi,

I have two tables one table contains column State which contains 1,2,3,4,5 and another table contains a column called state which contains Maharashtra,punjab,Haryana,Kerala.

Now i need to define a pivot table from both the table ,can you please define the process by using match function.

1=Maharashtra

2=punjab

3=Haryana

4=Kerala....

[robert_mika]

Use Applymap in load statemtent (script) instead (this is faster that match)

Don't join - use Applymap instead

Feeling Qlikngry?

How To /Missing Manual(18 articles)

[sunny_talwar]

Not sure what you mean, but Pick can work like this:

=Pick(StateNum, 'Maharashtra', 'Punjab', 'Haryana', 'Kerala')

[tresesco]

Are the tables linked? If linked properly, match() might not be required. QV does it by association automatically. Try to explain a bit more with data sample.

[PrashantSangle]

Hi,

Can you some more details of both tables.

How they are associated with each Other???

Regards,

[nagarjuna_kotha]

Can u share sample data ?

[engishfaque]

Dear Naresh,

Here it is,

=Pick(wildmatch(YourFieldName, 'Maharashtra', 'Punjab', 'Haryana', 'Kerala', '*'), Red(), Green(), Blue(), Black(), LightGray())

Kind regards,

Ishfaque Ahmed