Associate field

[pgalvezt]

Hello,

I have a table with account organization, And I need to create a new visualization structure. Actually I have SubAccount (Cods and names) And I need to group those fields: Propose name doesn't exist so I need to creat them and Group the subaccounts. The first part is ready.

I attached an example for better comprehenssion.

Thanks!

[stevedark]

I'm not sure what it is you are unable to do here.  If you load in two tables and there is a common field name between them (right down to the case of the field name) then they will automagically associate on load.

You can get cleverer with your associations by using functions such as the ApplyMap function, which will allow you to 'swap out' a key for a different value.  It can also allow you to map on an account structure - for example.

I have written a blog on ApplyMap that you can search for.  I will post a link here, but it may take a while to go through moderation.

Hope that helps,

Steve

[stevedark]

The URL for the ApplyMap blog post referenced above is:

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

[pgalvezt]

Hi Steve,

I Created a 2 Inline with 3 fields and works perfectly. Anyway thank you for reply this question.

Thanks!!