QlikView App Dev

[kaylaramsey2]

Hello,

I am trying to combine two dimensions into one.  I need every result of the first column but only one specific result of the second column.

I tried this:

=pick(match($Field, 'column1', 'column2'), column1, only({<column2 = {'12345'}>} column2))

However this keeps giving me an error.  Is there another way to combine these two columns?

[Vegar]

Have you considered solving this by creating the logic in your script?

Load

column1, 

column2,

If(column2=12345,12345,Column2) as Column12

From source;

[kaylaramsey2]

This would probably work.  I'd prefer it to go directly into the expression if it is possible.

Any thoughts?